Creating stacked bar on Y axis with line chart on Y2 axis in Numbers

Question

Level 1

8 points

Creating stacked bar on Y axis with line chart on Y2 axis in Numbers

Seems that I cannot create a chart with 2 y axes where the Y1 axis is a stacked bar and the Y2 axis is a line. But I don't think this can be true, so I'm reaching out here. There is no template for this option. Once I build the chart with one y axis I do not see any way to then create and define a second y axis.

Can anyone assist me? I'm a rather new Numbers user, but am generally proficient in spreadsheets.

[Re-Titled by Moderator]

MacBook Pro 13″, macOS 14.6

Posted on Feb 11, 2025 7:17 PM

Reply

Answer 1

Top-ranking reply

Camelot

Level 9

58,299 points

Feb 13, 2025 2:17 PM in response to ScottHanoi

Assuming you mean Stacked Column and not Stacked Bar, then... no

Numbers does support two-Y axes, where one chart is a Column and the other is a line, but this doesn't extend to Stacked Column (at least as far as I could work out).

I did try experimenting with overlays - essentially creating two separate charts (Stacked Column, and Line) and just positioning them over each other, which got close, but I couldn't move the second chart's axis to the right hand side, which kind of defeated the purpose.

Reply

Answer 2

ScottHanoi Author

Level 1

8 points

Feb 13, 2025 4:57 PM in response to Camelot

Thank you for looking into this. Yes, I meant "stacked column." The stacked column was going to show tallies of the different levels/categories of membership that comprise a total for a given month, while the line was going to show the amount of dues income per (total) member for the same month.

Google Sheets doesn't do this, either. I'll either go with using only one value for Y1 or create multiple charts, I guess.

Reply

Creating stacked bar on Y axis with line chart on Y2 axis in Numbers

Similar questions