How to Create a Clustered-Stacked Column Chart

By Dustin Lamb

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.

Step 1

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

Step 2

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 3

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

Step 4

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 5

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 6

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."