Create Column Chart In Excel. Using Excel, you can create a column chart and give it a brand new, appealing look. As one of the most common chart types, a column chart is useful to compare data points in one or more data series.
After you create a column chart, you can change the spacing between the columns. You can also create a floating column chart by hiding a data series in the chart.
Data that is arranged in columns or rows on a worksheet can be plotted in a column chart. 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.
Consider using a column chart when:
You have one or more data series that you want to plot.
Your data contains positive, negative, and zero (0) values.
You want to compare the data for numerous categories side by side.
When you create a column chart, you can choose one of the following column chart subtypes:
Clustered column and clustered column in 3-D Clustered column charts compare values across categories. A clustered column chart displays values in 2-D vertical rectangles. A clustered column in 3-D chart displays the data by using a 3-D perspective only. A third value axis (depth axis) is not used.
Clustered column chart and clustered column chart in 3-D
You can use a clustered column chart type 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).
NOTE: To present data in a 3-D format that uses three axes (a horizontal axis, a vertical axis, and a depth axis) that you can modify, use a 3-D column chart subtype instead.
Stacked column and stacked column in 3-D Stacked column charts show the relationship of individual items to the whole, comparing the contribution of each value to a total across categories. A stacked column chart displays values in 2-D vertical stacked rectangles. A 3-D stacked column chart displays the data by using a 3-D perspective only. A third value axis (depth axis) is not used.
Stacked column chart and stacked column chart in 3-D
You can use a stacked column chart when you have multiple data series and when you want to emphasize the total.
100% stacked column and 100% stacked column in 3-D 100% stacked column charts and 100% stacked column in 3-D charts compare the percentage that each value contributes to a total across categories. A 100% stacked column chart displays values in 2-D vertical 100% stacked rectangles. A 3-D 100% stacked column chart displays the data by using a 3-D perspective only. A third value axis (depth axis) is not used.
100% stacked column chart and 100% column chart in 3-D
You can use a 100% stacked column chart when you have 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 along the horizontal and the depth axes.
3-D column chart
You can use a 3-D column chart 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, while the vertical axis displays the values.
Cylinder, cone, and pyramid 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 exactly the same way. The only difference is that these chart types display cylinder, cone, and pyramid shapes instead of rectangles.The columns chart is great way to represent data like target/achieved, etc in the most visually oriented manner. http://www.myelesson.org