Skip to main content

How to create a stacked clustered column / bar chart in Excel?

This article, I will talk about how to create a stacked clustered column chart in Excel as below screenshot shown.

Create a stacked clustered column chart in Excel


Create a stacked clustered column chart in Excel

To create a stacked clustered column chart, first, you should arrange the data with blank rows, and put the data for different columns on separate rows.

For example, put the Q1 and Q2 data in separate rows, and then insert blank row after each group of data row and header row, please remember to delete the first cell header. You will get the new layout of data as below screenshot shown:

1. After arranging the data, select the data range that you want to create a chart based on, and then click Insert > Insert Column or Bar Chart > Stacked Column, see screenshot:

2. Right click the data series bar, and then choose Format Data Series, see screenshot:

3. In the Format Data Series pane, under the Series Options section, change the Gap Width to 0, see screenshot:

4. Then, the stacked clustered column chart has been created successfully, now, you can move the bottom legend to right or other position as you need. Right click the legend, and choose Format Legend, see screenshot:

5. In the Format Legend pane, select the position you need from the Legend Options tab, see screenshot:


More relative chart articles:

  • Create A Bar Chart Overlaying Another Bar Chart In Excel
  • When we create a clustered bar or column chart with two data series, the two data series bars will be shown side by side. But, sometimes, we need to use the overlay or overlapped bar chart to compare the two data series more clearly. In this article, I will talk about how to create an overlapped bar chart in Excel.
  • Create A Step Chart In Excel
  • A step chart is used to show the changes happened at irregular intervals, it is an extended version of a line chart. But, there is no direct way to create it in Excel. This article, I will talk about how to create a step chart step by step in Excel worksheet.
  • Highlight Max And Min Data Points In A Chart
  • If you have a column chart which you want to highlight the highest or smallest data points with different colors to outstand them as following screenshot shown. How could you identify the highest and smallest values and then highlight the data points in the chart quickly?
  • Create A Bell Curve Chart Template In Excel
  • Bell curve chart, named as normal probability distributions in Statistics, is usually made to show the probable events, and the top of the bell curve indicates the most probable event. In this article, I will guide you to create a bell curve chart with your own data, and save the workbook as a template in Excel.
  • Create Bubble Chart With Multiple Series In Excel
  • As we know, to quickly create a bubble chart, you will create all the series as one series as screenshot 1 shown, but now I will tell you how to create a bubble chart with multiple series as screenshot 2 shown in Excel.

  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns and Keeping Data; Split Cells Content; Combine Duplicate Rows and Sum/Average... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Favorite and Quickly Insert Formulas, Ranges, Charts and Pictures; Encrypt Cells with password; Create Mailing List and send emails...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • Pivot Table Grouping by week number, day of week and more... Show Unlocked, Locked Cells by different colors; Highlight Cells That Have Formula/Name...
kte tab 201905
  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Comments (2)
Rated 5 out of 5 · 1 ratings
This comment was minimized by the moderator on the site
Foi o gráfico mais rápido e completo que já fiz! Obrigada !!
Rated 5 out of 5
This comment was minimized by the moderator on the site
Suveränt förklarat! Funkade perfekt.
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations