I’m trying to create a ‘stacked bar Pareto chart’ - i.e. a stacked bar chart, that also shows the cumulative values for each of the two series as lines, using a secondary y-axis.
Making a stacked bar chart is straightforward, as is making a Pareto chart with a single series; but I can’t see a way to combine the two. It feels like it should be possible using a Combo Chart, but I can’t quite work out how.
Very grateful for any suggestions. In case it helps, I’ve attached a hacked-up example showing what I’m trying to get to.
