You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Stacked bars with 2 axis?

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

Posted on Nov 12, 2024 9:36 AM

Reply
Question marked as Top-ranking reply

Posted on Nov 13, 2024 1:29 PM

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.

1 reply
Question marked as Top-ranking reply

Nov 13, 2024 1:29 PM in response to Natxosailor

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?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.