Can I insert multiple scales on the Y axis of a single XY graph?

S

Saba Demian

I am trying to plot three parameters on a single XY line chart. Is it
possible io have three different scales charted to cover all the three
parameters which are quite variable numerically? Using Excel 2000
 
B

Bernard Liengme

No, you can only have a left and a right y-axis.
Workaround: let's assume one series has very small numbers; have a column
with these values multiplied by say 1000; plot this column and use a legend
like "voltage x 1000"
If one series is too large, have a column with the numbers divided; legend
"Sales in $million)
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Combining a 2-D column graph and a 2-D line graph on the same char 3
scaling of columns: same maximum height despite different ranges 2
Use text descriptors as Y axis units 1
Using a 'Name' to Update Chart Titles & "Y" Axis Scale 2
grid on dual y axis graph 0
XY Charts 1
Tertiary Y Axis 1

Top