Line x-y graph: How to add a second 'scale' on the RIGHT side of the graph?

Question

Level 1

71 points

Line x-y graph: How to add a second 'scale' on the RIGHT side of the graph?

On a Mac, searched how to add a second Y-axis on the right side of the line graph and didn't find anything.

The left axis uses a line graph with a scale up to 60, but on the right side I'd like to have a scale that would be a few multiples of that, say, 240 f.e.

Somewhere, I've seen this setup as an example so it is possible.

Not fluent in graphs because only do this every once in a while, then forget and struggle to make one again (its been at least a year now. groan!).

using a Catalina map

Posted on Mar 14, 2024 1:03 PM

Reply

Answer 1

Badunit

Level 7

31,202 points

Mar 14, 2024 4:27 PM in response to Searchin99

Click on one of the bars then use the format sidebar to "show series as" a line.

Reply

Answer 2

Badunit

Level 7

31,202 points

Mar 14, 2024 2:24 PM in response to Searchin99

There is a two-axis category chart. The icon has columns and a line but it can be any combination of lines, columns, and areas. This a category chart, not a true X-Y chart (i.e., not a "scatter" chart). As such, the X axis data points are all evenly spaced. The X axis is text categories, it is not treated as numbers even if it is numbers. For a lot of data it doesn't matter because it is evenly spaced in the table anyway.

Reply

Answer 3

Searchin99 Author

Level 1

71 points

Mar 14, 2024 2:43 PM in response to Badunit

That is essentially the same one I'd been looking at but with a line instead of the bars.

Currently the graph has two variables on the Y-axis left side, so if another variable line-graph can be graphed using a different scale on the right side that would great.

attached is the closest one so far, unfortunately, it has bars.

I didn't realize the bars can be a line instead so that is apparently a way forward.

(PS: spell check changed my MBP to "map" in the original post and didn't catch it.)

Reply