This indict discusses the most usual chart types, and sub-types, supported by Excel. For related tutorials, see our chart & Graph info Center. And if you develop a lot of charts, we like coherent Graphs: many information Excel Charts (affiliate link). This book is well-organized and plainly explains the principles and "how to" of an excellent chart design.

You are watching: A chart that compares three set of values in a three-dimensional chart is _____.


*

The Pie Chart

A Pie Chart screens one collection of data. A data collection is a heat or shaft of numbers supplied for charting. In the worksheet below, we have outlined a solitary data series. If we had actually selected multiple series for the Pie Chart, Excel would neglect all yet the first.

*
Single Data Series

Excel offers the heat heading (series identifier) for the graph title and displays the data together proportional slices that a pie (1st photo below). One have the right to customize the design of the pie chart so one of two people numeric values or your percentages screen on peak of the slices the pie.

The legend can be relocated to the top, bottom, left, right, or peak right ("corner" in older versions) the the chart. Legend names have the right to be readjusted by an altering the obelisk headings in the paper or editing the chart directly in new Excel versions.


*
*
*

Popular Pie graph sub-types include Pie graph in 3-D (2nd chart above), explosive Pie chart (3rd chart above), and Exploded Pie in 3-D. Various other sub-types encompass the Pie of Pie and also Bar that Pie - where a second pie or bar is created from certain values in the first pie. To customize, right-click top top the segment in the very first pie and also select "Format Data Point."


The shaft Chart

The pillar Chart successfully compares a single set of data points, yet it shines once comparing multiple series. Outlined in red, the image listed below shows the three data series we"re charting. Notification that we perform not incorporate the totals in our data series.

*
Multiple Data Series

Because Excel supplies a different color for each data series, it"s basic to see just how a single collection changes over time, or to compare multiple collection over a given time period. The Clustered shaft Chart is especially popular.


*
Clustered column Chart
*
Stacked pillar Chart

With the Stacked tower Chart, data points for each time period are "stacked" atop each other. This chart kind shows each data point"s percentage the the total. Also available is the 100% Stacked pillar Chart, wherein each worth is presented as a part of 100%.


*
100% Stacked column Chart

In a tower Chart, the vertical axis always displays numeric values, and also the horizontal axis displays time, names, or other category. By default, Excel plots whichever has actually the most entries, heat or tower data, top top the horizontal axis. Because that example, if plotting five rows and two columns, heat headings would reside follow me the horizontal axis. This have the right to be flipped roughly by customizing the Excel chart.

All shaft Charts have three-dimension versions—the Stacked column Chart is 3-D. But the "3-D tower Chart" is special because the graph itself is three-dimensional making use of the X, Y, and Z axes. The very first chart below is a 3-D pillar Chart of our data series.


*
3-D shaft Chart
*
3-D Pyramid Chart

In more recent versions the Excel, cylinders, pyramids, and cones deserve to be used rather of bars for most of the tower charts. The second chart above shows a 3-D Pyramid Chart.

A occupychristmas.org Tutorial


The line Chart

*

The heat Chart is especially efficient in displaying trends. The vertical axis (Y-axis) constantly displays numeric values and the horizontal axis (X-axis) display screens time or other category.

The an initial image mirrors the Line through Markers chart of our single data series. Markers—the circles, squares, triangles, or various other shapes which mark the data points—are optional, and Excel screens a distinct marker in shape and/or color for each data series.

*

The line Chart is equally efficient in displaying fads for multiple collection as presented in the above Line chart without markers. Notification that each line is a various color.

Though no as vibrant as the various other charts, the is simple to check out how reliable the line Chart in mirroring a trend for a solitary series, and comparing trends for multiple collection of data values.

Besides the heat Chart, we have the Stacked line Chart and the 100% Stacked heat Chart - with or there is no markers. A 3-D heat Chart is available, but the line Chart go not display screen data well in 3 dimension.

The Bar Chart

The Bar graph is favor a shaft Chart lie on that side. The horizontal axis that a Bar Chart includes the numeric values. The first chart below is the Bar Chart for our solitary series, Flowers.

When to use a Bar graph versus a tower Chart counts on the type of data and user preference. Occasionally it is worth the moment to create both charts and compare the results. However, Bar Charts do tend to display and also compare a large number that series much better than the other chart types.


*
*

The Area Chart

*

Area Charts are like Line Charts except that the area below the plot heat is solid. And like heat Charts, Area Charts room used generally to show trends over time or various other category. The chart at left is an Area Chart because that our solitary series.

*

Also easily accessible are the stack Area Chart and also 100% stack Area Chart. Each comes in 2-D format and also in true 3-D style with X, Y, and also Z axes. The chart at ideal is our 3-D Area Chart and effectively displays our 3 series.

In countless cases, the 2-D variation of the Area Chart display screens multiple collection of data poorly as collection with lesser values might be completely hidden. In the an initial chart below, flowers is totally hidden, and just a wee bit of tree peaks through. No an reliable chart!


*
*

The Scatter Chart

The purpose of a Scatter chart is come observe just how the values of two series compares in time or other category. To illustrate the Scatter Chart, us will use the worksheet values shown below:

*

According to Scatter Plots (U. The Illinois), "Scatter plots are comparable to line graphs in that they usage horizontal and also vertical axes come plot data points. However, they have a very particular purpose. Scatter plots display how lot one variable is impacted by another. The relationship between two variables is dubbed their correlation."

The series pair has a hopeful Correlation if they boost similarly, and a negative Correlation if they both diminish in prefer manner. Otherwise, they have actually No Correlation.

Excel does not use labels from the worksheet to brand the horizontal axis. It numbers the X-axis chronologically.

The Scatter Chart comes in several various formats: markers can indicate the data points, and the points deserve to be unconnected or associated with smooth or directly lines. The very first chart below is a Scatter chart with only Markers, and also the second chart is a Scatter Chart v Smooth Lines.

*
*

In general, markers work-related well when the number of data points is small, and also smooth lines without markers are frequently used as soon as the variety of data clues is large. However it is finest to try the different sub-types to view which one finest presents your data. Because that a an excellent discussion ~ above Scatter Plots, see Scatter Plots - U. The Illinois.

A occupychristmas.org Tutorial


Other chart Types

Excel supplies other graph types, such together Stock, Surface, Doughnut, Bubble, and also Radar. To locate a menu of all easily accessible chart varieties in newer Excel versions, begin to insert any chart type and click All Chart types ... The image listed below shows the food selection that displays—menu might look different on your variation of Excel.

*

Customizing Excel Charts

Customizing a chart can take a long time uneven a reasonable order is followed. As soon as Microsoft modification its Office commodities for the 2007 version, it greatly enhanced the charting function. In some methods there space too numerous options.

See more: Gi Joe Big Boa (V1) G

We have created a indict that describes the customizing choices for charts in newer versions that Excel, in addition to a recommended order in which come proceed.