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