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–
To cluster the bars together, we used the Cluster option under Format Bars and Series.
Here’s the chart.
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.