I'm trying to make a stacked bar chart with either a line chart or scatter plot overlaid. I have the chart generally looking the way I want it, but I can't get data value labels to appear for the line/scatter. I'm essentially showing a series of counts as a stacked bar with a capacity line overlaid. I tried using the trick of adding another bar chart that matches the line/scatter data to then make it transparent/add labels, but it just adds itself to the stacked bar. Any ideas?
I've attached a workflow with data and some example tools trying to make it happen. Here's also a PPT mockup of essentially what I'm trying to do.
Thanks in advance!
Solved! Go to Solution.
Hi @blairmbailey
I think I've worked out how to do this, just about.
So it looks like only Bar charts can have labels, but once you try and invisible bar chart trick, because the first bars are stacked, that stacks the invisible bars on top and everything breaks.
As I see it, you can therefore either create 2 charts, one with the lines and stacked bar, and one with the line labels (and invisible total stacked bar heights to align axis), and then overlay the invisible chart on top
Or you can create a runningsum of your values per month, then sort your data by this descending, and overlay the bars, rather than stack. This means that you can do the normal invisible bar trick to get labels on the line chart.
I've attached both approaches here.
Hope that helps,
Ollie
