Forum Home
Press F1
 
Thread ID: 26474 2002-10-28 07:30:00 XL, how to put a third Y axis on the RHS of graph John W (523) Press F1
Post ID Timestamp Content User
93812 2002-10-28 07:30:00 Bugger, I knew how to do this a few years back, but for the life of me I can now. Spent nearly an hour trying to achieve this last week, no luck.

Here is the row data
A1 - A10 Cell entries stepped from 200 down to 20 or so
B1 - B10 " " " " 2 exponentially 500 or so
C1 - C10 " " " " 1.5 in increments to 3 or so.

I need to scale the 3 Y (vertical axis) on the RHS to suit the C column range of data.

Thanks......John W 		John W (523)
93813 2002-10-28 07:37:00 Put ALL 3 data values into the chart on the Left Hand Side axis.

Then right-click the data series (in the chart) that you want as the secondary axis

Select "format data series" and click the Axis tab.

Select "secondary axis" and OK 		godfather (25)
1