ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Can I insert multiple scales on the Y axis of a single XY graph? (https://www.excelbanter.com/charts-charting-excel/21277-can-i-insert-multiple-scales-y-axis-single-xy-graph.html)

Saba Demian

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

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
--
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




fernando cinquegrani

[Saba Demian] scrive in

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


see a sample:
http://groups.google.it/groups?hl=it...GP14. phx.gbl
.f



Jon Peltier

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