![]() |
Can I insert multiple scales on the Y axis of a single XY graph?
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 |
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 -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Saba Demian" <Saba wrote in message ... 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 |
Look at this page:
http://peltiertech.com/Excel/Charts/TertiaryAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Saba Demian wrote: 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 |
All times are GMT +1. The time now is 09:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com