Cluster Bar Drawing

How Do I Make This Chart?

A customer recently sent us this drawing and asked how to make the chart. Here’s how we did it.

We started with a stacked bar chart and added series for the lines. From Format Bars and Series we chose to plot Series 2, 3 and 4 as a line on the 2Y axis (format as %). We used 3 series for the lines instead of 1 so that the lines would only appear in the bars and not as a continuous line across the chart. Here’s the data structure–

Data Structure

To cluster the bars together, we used the Cluster option under Format Bars and Series.

CQ Post Cluster By Example

Here’s the chart.

Cluster Bar Line Example

You could achieve something similar by using net lines for the 2nd series or adding a data row instead of including the lines on the chart.