Let’s say we have the below dataset in the table. It contains the number of sales of the keyboard in 4 consecutive years in 2 metro cities in India.
Now to create the Stacked Column Chart based on the above table please follow the below steps.
- Select the entire table(A1:C5)
- Click the insert tab in menu bar
- In the Chart group, click the ‘Insert Column or Bar Chart’ icon
4. Select the chart style as ‘Stacked Column’ Under 2-D Column.
5. The chart will look like below. The X-axis which is the horizontal axis shows the year and the Y-axis which is the vertical axis shows the sale count. You can edit the Chart Title on top of the chart as we edited the chart title as “Stacked Column Chart”. In this example, the Stacked Column chart in Excel is useful to show the proportion of the sale count in Kolkata and Delhi of the whole keyboard sale count over the 4 consecutive years.
6. The color codes for Kolkata and Delhi sale count variations are mentioned just below the Stacked Column chart. If you change the order of the columns, the order of plotting colors in the Stacked Column chart will also change(see below).
- We must NOT provide any column header for the leftmost column of the table which we need to display as X-axis in the Stacked Column chart.
- Click Here to check the 3D Stacked Column Chart in Excel.