How to create Stacked Column Chart in Excel?

  1. Take sample data.

Stacked Chart

 

2. Select data from sample data, then go to the ribbon, select Insert, and select your chart type from the chart group.

Stacked Chart

 

3. Select Chart type as 2-D stacked column.

Stacked Chart

 

4. The Chart looks below.

Stacked Chart

 

5. To Remove Gridline, click on the chart then select the + button, and uncheck the Gridline.

Stacked Chart

 

6. To change the Gap width, right-click on Chart and select Format Data Series.

Stacked Chart

 

7. Choose the gap width to 60%.

Stacked Chart

 

8. To change the first color in the bar, right-click on the chart and select Format Data, in Format Data Series select Fill and choose your color.

Stacked Chart

 

9. To change the second color in the bar, right-click on the chart and select Format Data, in Format Data Series select Fill and choose your color.

Stacked Chart

 

10. To change the legend Option, right-click on the legend and select Format Legend, in Legend Option select Top.

Stacked Chart

 

11. To give Data Labels in the chart click on your chart and select the + button to give your Data labels. Select Data labels and click on Inside Base or any other option.

Stacked Chart

 

12. To give appropriate chart title, select the title and write your desired title.

Stacked Chart

 

13. The chart looks below.

Stacked Chart

Leave a Comment

Your email address will not be published. Required fields are marked *

Categories