Stacked Bar/Column Chart
Overview
Data that is arranged in columns or rows on a worksheet can be plotted in a bar chart. Bar charts illustrate comparisons among individual items.
Stacked bar charts show the relationship of individual items to the whole. A stacked bar/column in 3-D chart displays the rectangles in 3-D format; it does not display the data in 3-D format.
Chart Building
As stacked charts should show contribution of different components to the total, we will demonstrate them on an imaginable ACME FastFood, Corp. sales. Let's assume that it sells Ice Cream, Chocolate Bar and Coke all through the year.
So, we have three series of data - one series for each product, and we give proper names to each series:
Now we have to tell Y Axis to display these series in as stacked columns:
Everything is ready, here is a sample stacked column chart:
![](img/Samples/sample-stacked-column-chart.png)
Stacked Bar Chart
Just change "plot_type" to "CategorizedHorizontal" and get your data displayed as a bar chart:
Also, let's add tooltips and make them more informative, to that we will change their format:
Here is a sample stacked bar chart:
![](img/Samples/sample-stacked-bar-chart.png)
3D Stacked Column Chart
One more quick feature demo - enabling 3D mode makes column chart three-dimensional:
The sample of 3D Column chart at a glance:
![](img/Samples/sample-3d-stacked-column-chart.png)