Excel Stacked Bar Chart (Table of Contents)
Stacked Bar Chart in Excel
A stacked bar chart is a type of bar chart used in excel for the graphical representation of part-to-whole comparison over time. This helps you to represent data in a stacked manner. This type of graph is suitable for data which is represented in different parts and one as a whole. The gradual variation of different variables can be picturized using this.
The stacked bar graph can be implemented in 2D or 3D format. From the Insert menu, the chart option will provide different types of charts. Stacked bar chart comes under the bar chart. Two types of stacked bar charts are available. Stacked bar chart and 100% stacked bar chart. Where the stacked bar chart represents the given data directly. But 100% stacked bar chart will represent the given data as the percentage of data that contribute to a total volume in a different category.
Variety of bar charts are available and according to the data you want to represent the suitable one can be selected. 2D and 3D stacked bar charts are given below. The 100% stacked bar chart is also available in 2D and 3D style.
How to Create a Stacked Bar Chart in Excel?
Stacked Bar Chart in excel is very simple and easy to create. Let us now see how to create a Stacked Bar Chart in excel with the help of some examples.
Example #1 – Stacked Chart Displayed Graphically
Fruit conception of three different patients is given by a dietitian. Different fruits and their conception are given. Since the data consist of three different persons and five different fruits, a stacked bar chart will be suitable to represent the data. Let’s see how this can be graphically represented as a stacked bar chart.
- John, Joe, Jane are the 3 different patients, and the fruits conception are given as below.
- Select the column Category and 3 patient’s quantity of conception. Select Insert from the Menu.
- Select the See All Charts option and get more charts types. Click on the small down arrow icon.
- You will get a new window to select the type of graph. The recommended charts and All Charts tab will be shown. Click on All Charts tab.
- You can see a different type of graph is listed below it. Select the Bar graph since we are going to create a stacked bar chart.
- Different bar charts will be listed. Select the Stacked Bar graph from the list.
- Below are the two format styles for stacked bar chart. Click on any one of the given styles. Here we have selected the first one and then press the OK button.
- The graph will be inserted into the worksheet. And it is given below.
- For more settings, you can press the “+” symbol right next to the chart. You can insert the axis name, heading, change color, etc.
- The chart will finally look as below.
Three different colors represent three persons. The bar next to each fruit shows its conception by different patients. From the graph, it is easy to find who used a particular fruit more, who consumes more fruits, which fruit consumes more apart from the given five.
Example #2 – Create 3-D Stacked Bar Chart
Sales report of different brands are given. Brand names and sales are done for 3 years 2010, 2011, 2012. Let’s try to create a 3-D stacked bar chart using this.
- Sales done for different brands and years are given as below.
- Select the data and go to chart option from Insert menu. Click on bar chart select 3-D Stacked Bar chart from the given styles.
- The chart will be inserted for the selected data as below.
- By clicking on the title you can change the tile.
- Extra settings to change the color and X, Y-axis names, etc.
- The axis name can be set by clicking on the “+” symbol and select Axis Titles.
- The chart for the sales report will finally look as below.
The sales in different years are shown in 3 different colors. The bar corresponding to each brand shows sales done for a particular one.
Example #3 – Create 100% Stacked Bar Chart
In this example, we are trying to graphically represent the same data given above in a 3-D stacked bar chart.
- The data table looks as below with brand names and sales done for different periods.
- By selecting the cell from B2: E11 go to Insert menu. Click on Chart option. From Bar Charts, select the 100% Stacked Bar Chart from 2-D or 3-D style. Here we selected form 2-D style.
- The graph will be inserted into the worksheet. And it is given below.
- The color variations can be also set by right-clicking on the inserted graph. The color fill options will be available. The final output will be as below.
The Y-axis values are given in percentage. And the values are represented in percentage of 100 as a cumulative.
Things to Remember About Stacked Bar Chart in Excel
- For the data which is given as different parts and cumulated volume can be easily represented using a stacked bar chart.
- Multiple data or gradual variation of data for a single variable can effectively visualize by this type of graphs.
- Stacked bar charts are helpful when you want to compare total and one part as well.
- According to the data set select the suitable graph type.
Recommended Articles
This has been a guide to Stacked Bar Chart in Excel. Here we discuss how to create a Stacked Bar Chart in excel along with excel examples and downloadable excel template. You may also look at these suggested articles –
