How to Create a Clustered-Stacked Column Chart

Creating a clustered-stacked column chart in Microsoft Excel can be complicated. But this chart can be created in several steps using Excel. You will need to enter your data into the spreadsheet in a specific way, use the stacked-column chart option and then format the table.

...
You can create advanced charts using Microsoft Excel.

Step

Click "Start," "All Programs," "Microsoft Office" and open "Microsoft Excel."

Step

Enter your column headings as you would normally into the spreadsheet. Add your row headings, but leave one blank cell for each graph cluster column that you want.

Step

Enter the data into the spreadsheet. When entering the data, use a separate row for each cluster that you want to create.

Step

Click in the upper-right corner of the spreadsheet and drag the cursor so that all the cells containing data are selected. Click the "Insert" menu at the top of the window.

Step

Click "Column" and the second option in the "2-D Column" section, which is "Stacked Column." Right click one of the columns in the chart, and select "Format data series."

Step

Use the slider in the "Gap Width" section and slide it all the way to the left to eliminate the gap between the clusters. Click "Close."