This tutorial discusses the a lot of common chart types, and sub-types, supported by Excel. For related tutorials, watch our Chart & Graph Indevelopment Center. And if you produce a lot of charts, we choose Meaningful Graphs: Informative Excel Charts (affiliate link). This book is well-arranged and plainly defines the values and also "how to" of excellent chart style.

You are watching: The area along the bottom of a chart that identifies the categories of data is the


*

The Pie Chart

A Pie Chart screens one series of data. A data series is a row or column of numbers provided for charting. In the worksheet listed below, we have outlined a single information series. If we had selected multiple series for the Pie Chart, Excel would certainly neglect all yet the initially.

*
Single File Series

Excel supplies the row heading (series identifier) for the chart title and displays the data as proportional slices of a pie (first picture below). One have the right to customize the style of the pie chart so either numeric worths or their percentages screen on peak of the slices of pie.

The legend have the right to be relocated to the peak, bottom, left, best, or peak best ("corner" in older versions) of the chart. Legend names can be readjusted by altering the column headings in the sheet or editing and enhancing the chart straight in brand-new Excel versions.


*
*
*

Popular Pie Chart sub-forms encompass Pie Chart in 3-D (2nd chart above), Exploded Pie Chart (third chart above), and Exploded Pie in 3-D. Other sub-types encompass the Pie of Pie and Bar of Pie - wright here a second pie or bar is created from particular worths in the first pie. To customize, right-click the segment in the first pie and choose "Style File Point."


The Obelisk Chart

The Tower Chart successfully compares a single collection of information points, yet it shines when comparing multiple series. Outlined in red, the image below mirrors the 3 data series we"re charting. Notice that we do not include the totals in our data collection.

*
Multiple Documents Series

Since Excel uses a different color for each data collection, it"s straightforward to see how a solitary series alters over time, or compare multiple series over a given time duration. The Clustered Tower Chart is particularly renowned.


*
Clustered Tower Chart
*
Stacked Pillar Chart

With the Stacked Shaft Chart, information points for each time duration are "stacked" apeak each various other. This chart form reflects each data point"s percent of the total. Also obtainable is the 100% Stacked Obelisk Chart, where each value is displayed as a part of 100%.


*
100% Stacked Pillar Chart

In a Tower Chart, the vertical axis always display screens numeric values, and also the horizontal axis display screens time, names, or other category. By default, Excel plots whichever has actually the the majority of entries, row or column information, on the horizontal axis. For instance, if plotting five rows and two columns, row headings would reside alengthy the horizontal axis. This have the right to be flipped approximately by tailoring the Excel chart.

All Column Charts have actually three-measurement versions—the Stacked Column Chart is 3-D. But the "3-D Shaft Chart" is special because the chart itself is three-dimensional using the X, Y, and Z axes. The first chart listed below is a 3-D Column Chart of our data series.


*
3-D Obelisk Chart
*
3-D Pyramid Chart

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

A muzic-ivan.info Tutorial


The Line Chart

*

The Line Chart is particularly reliable in displaying trends. The vertical axis (Y-axis) constantly display screens numeric worths and also the horizontal axis (X-axis) display screens time or other category.

The initially image shows the Line with Markers chart of our single data collection. Markers—the circles, squares, triangles, or various other forms which mark the data points—are optional, and also Excel displays a distinctive marker in shape and/or shade for each data series.

*

The Line Chart is equally efficient in displaying patterns for multiple series as presented in the above Line Chart without markers. Notice that each line is a various shade.

Though not as colorful as the various other charts, it is basic to see exactly how effective the Line Chart in reflecting a trend for a solitary series, and comparing fads for multiple series of information worths.

Besides the Line Chart, we have the Stacked Line Chart and also the 100% Stacked Line Chart - via or without markers. A 3-D Line Chart is obtainable, yet the Line Chart does not display information well in 3 measurement.

The Bar Chart

The Bar Chart is favor a Shaft Chart lying on its side. The horizontal axis of a Bar Chart contains the numeric values. The initially chart listed below is the Bar Chart for our single series, Flowers.

When to use a Bar Chart versus a Shaft Chart depends on the form of data and user preference. Sometimes it is worth the time to produce both charts and also compare the results. However before, Bar Charts execute tfinish to display screen and compare a huge number of series much better than the other chart types.


*
*

The Area Chart

*

Area Charts are favor Line Charts except that the area below the plot line is solid. And choose Line Charts, Area Charts are supplied primarily to display trends over time or various other category. The chart at left is an Area Chart for our single series.

*

Also available are the Stacked Area Chart and also 100% Stacked Area Chart. Each comes in 2-D format and in true 3-D format with X, Y, and Z axes. The chart at right is our 3-D Area Chart and also properly screens our three series.

In many kind of situations, the 2-D version of the Area Chart screens multiple series of data poorly as series through lesser values may be totally concealed. In the initially chart listed below, Flowers is completely surprise, and just a wee little of Trees peaks through. Not an effective chart!


*
*

The Scatter Chart

The objective of a Scatter Chart is to observe exactly how the values of 2 series compares over time or other category. To illustrate the Scatter Chart, we will use the worksheet worths displayed below:

*

According to Scatter Plots (U. of Illinois), "Scatter plots are equivalent to line graphs in that they use horizontal and also vertical axes to plot data points. However before, they have actually a really specific objective. Scatter plots show just how a lot one variable is impacted by another. The partnership between 2 variables is called their correlation."

The series pair has actually a Positive Correlation if they rise similarly, and also a Negative Correlation if they both decrease in like manner. Otherwise, they have actually No Correlation.

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

The Scatter Chart comes in several different formats: markers have the right to indicate the data points, and the points deserve to be unconnected or connected with smooth or directly lines. The first chart below is a Scatter Chart through Only Markers, and the second chart is a Scatter Chart through Smooth Lines.

*
*

In general, markers occupational well as soon as the number of data points is small, and also smooth lines without markers are often provided once the number of information points is huge. But it is best to try the different sub-types to watch which one finest presents your data. For a great conversation on Scatter Plots, see Scatter Plots - U. of Illinois.

A muzic-ivan.info Tutorial


Other Chart Types

Excel offers various other chart forms, such as Stock, Surchallenge, Doughnut, Bubble, and Radar. To locate a food selection of all available chart forms in more recent Excel versions, begin to insert any chart form and click All Chart Types ... The photo below shows the food selection that displays—menu might look various on your variation of Excel.

*

Customizing Excel Charts

Customizing a chart have the right to take a lengthy time unless a logical order is followed. When Microsoft revised its Office commodities for the 2007 variation, it significantly magnified the charting feature. In some methods tbelow are too many options.

See more: Why Is It Important For The Nuclear Membrane To Disintegrate During Mitosis ?

We have actually created a tutorial that explains the customizing options for charts in newer versions of Excel, in addition to a recommfinished order in which to proceed.