Hi! I'm working with numbers charts. I am trying to view in the same chart two sets of data as stacked columns and to superpose a third set of data as a line with a second "Y" axis. All I was able to do is a combined Bar / Line chart with 2 axis... but this does not seem to work with stacked bars...
Is this an app limitation or there is a way around this? Thanks!
iMac 24″, macOS 15.0
Your options with 2-axis charts are limited to Bar, Line, or Area. There's no facility to incorporate a stacked bar graph as one of the axis.
The best I can think of is two separate charts - one for your stacked bar, and the other with your line, then position the two charts on top of each other, causing an overlay.
For example, this is two separate charts - a stacked bar with a 2D line chart overlaid:
You may need to tweak the axis settings to get it to work.
Your options with 2-axis charts are limited to Bar, Line, or Area. There's no facility to incorporate a stacked bar graph as one of the axis.
The best I can think of is two separate charts - one for your stacked bar, and the other with your line, then position the two charts on top of each other, causing an overlay.
For example, this is two separate charts - a stacked bar with a 2D line chart overlaid:
You may need to tweak the axis settings to get it to work.
Stacked bars with 2 axis?
