Column Charts in PowerPoint
Learn about Column Charts, and how you can use them within PowerPoint.
Author: Geetesh Bajaj
What is a Column Chart?
A column chart is probably the most simple chart type that you can create in PowerPoint. What makes a column chart the most preferred chart type is that it follows human thinking -- we are all used to identifying a taller column as representing more success, more sales, more profits, more reach, etc. And column charts fit in perfectly with such human thinking! No wonder they are so popular.
Like bar or line charts, column charts also work best to compare values over a period of time such as days, weeks, months, quarters, or years. Of course, you can also use column charts to categorize more than just time -- the categories you choose are entirely for you to decide!
In the sample column chart that you can see in Figure 1, below you will notice that this period of time typically shows up within the X axis, which is also called the Category axis because it represents categories. The categories in this case are the successive years, highlighted in purple within Figure 1, below.
Figure 1: Column Chart sample
The same categories can also be found within the data used to create this column chart, as shown in Figure 2, below. Note that the years can be seen in the purple shaded areas within Figure 2.
Figure 2: Data used for the Column Chart
Similarly the areas shown in red within Figure 2 correspond to the Series within the data. In the case of our sample data, these are the fruits, Apples and Bananas. Within the chart, the Series shows up as the Legend, as highlighted in red within Figure 1, earlier on this page.
Where can Column Charts be used?
Column charts are useful for showing data changes over a period of time or for illustrating comparisons among items.
In column charts, categories are typically organized along the horizontal axis and values along the vertical axis.
You can have column charts that have one series, one category, or multiple series and categories.
Can we see some samples?
To see a sample presentation containing column chart types and subtypes, scroll down to the bottom of this page.
Are all column charts the same, or are there variations?
Column charts have the following sub-types within PowerPoint -- do note that all these sub-types are not available in all PowerPoint versions:
- Clustered Column: A clustered column chart compares values across
categories and displays values in 2-D vertical rectangles.
- Stacked Column: Stacked column charts show the
relationship of individual items to the whole, comparing the contribution of each value
to a total across categories and displays values in 2-D vertical stacked rectangles.
- 100% Stacked Column: 100% stacked column charts
compare the percentage that each value contributes to a total across categories displaying
values in 2-D vertical 100% stacked rectangles.
- 3-D Clustered Column: A clustered column in 3-D displays the data
by using a 3-D perspective only. A third value axis (depth axis) is not used.
The clustered column chart can be used when you have categories that represent:
- Ranges of values (for example, item counts).
- Specific scale arrangements (for example, a Likert scale with entries, such as strongly agree, agree, neutral, disagree, strongly disagree).
- Names that are not in any specific order (for example, item names, geographic names, or the
names of people).
- 3-D Stacked Column: This chart type displays the data by using a
3-D perspective only. A third value axis (depth axis) is not used.
The stacked column chart can be used when you have categories that represent:
Multiple data series and when you want to emphasize the total.
- 3-D 100% Stacked Column: The 3-D 100% stacked column chart
displays the data by using a 3-D perspective only the third value axis (depth axis) is not used.
The 100 % stacked column chart can be used when you have categories that represent:
Three or more data series and you want to emphasize the contributions to the whole, especially if the total is the same for each category.
- 3-D Column: 3-D column charts use three axes that you can modify
(a horizontal axis, a vertical axis, and a depth axis), and they compare data points
(data points: Individual values plotted in a chart and represented by bars, columns,
lines, pie or doughnut slices, dots, and various other shapes called data markers. Data
markers of the same color constitute a data series.) along the horizontal and the
3-D column chart can be used when you want to:
Compare data across the categories and across the series equally, because this chart type shows categories along both the horizontal axis and the depth axis, whereas the vertical axis displays the values.
- Cylinder, Cone, and Pyramid: The Cylinder, Cone, and Pyramid charts are available in the same Clustered, Stacked, 100% Stacked, and 3-D chart types that are provided for rectangular column charts, and they show and compare data the same way. The only difference is that these chart types display cylinder, cone, and pyramid shapes instead of rectangles.
Column Chart Type in PowerPoint Sample Presentation
Click above to view on SlideShare
Click above to view on YouTube
Have your ever used keyboard shortcuts and sequences in PowerPoint? Or are you a complete keyboard aficionado? Do you want to learn about some new shortcuts? Or do you want to know if your favorite keyboard shortcuts are documented?
Go and get a copy of our PowerPoint Keyboard Shortcuts and Sequences E-Book.