How to Create a Clustered-Stacked Column Chart

Written by dustin lamb
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Create a Clustered-Stacked Column Chart
You can create advanced charts using Microsoft Excel. (David Lees/Digital Vision/Getty Images)

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.

Skill level:


  1. 1

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

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

  3. 3

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

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

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

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

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.