How to Create 2D Stacked Column Chart in Excel

Stacked Column charts are very useful to create chart to compare data with use of vertical rectangles of all data of a category to other categories.

First off all we have to create a simple data table like below I have created.

After this next step select this data table. There are 2 simple way to select table.

I)          Click on first cell and move forward with arrow key to last cell in data table with shift key. After this with shift key and down key go down.

II)        Either you can use mouse to select whole data table

Next step you have to do. Go menu tab and click on insert option you will see column option, click on it.

A drop down option type menu will appear where you will see 2D Column options first.

In 2D Column second option from left is stacked column. 

Click on it

Now Stacked Column chart has been created.

Watch tutorial to create 2D Stacked Column Chart in Excel