Cluster Chart Excel. A chart will appear that has each of the columns of data displayed as a stacked column chart but with a gap between columns. For these reasons bar charts are almost always a good choice.
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. Jan 29 2017 Select the data that you will use to create a combined clustered and stacked bar chart. Add Sum Labels to Chart.
Select cells A1 through I13 and then click on the Insert.
A clustered column chart displays more than one data series in clustered vertical columns. Add Sum Labels to Chart. Select the stacked column chart and click Kutools. 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.
