Plotting - 3 Y Axis

[Alex]

I am trying to create a plot of
y1 vs x
y2 vs x
y3 vs x

where y1 varies from 1 to 10
y2 varies from 1 to 10,000
y3 varies from 1 to 100,000.

Hence I need to find a way of creating THREE VERTICAL
axis in ONE plot - one vertical axis going from 1 to 10,
next from 1 to 10,000 and last one from 1 to 100,000.

Could you please help me?

Thanking you Alex.

 

[Tushar Mehta]

Maybe, you can adapt the ideas behind 'Stacked Charts' at
http://www.tushar-mehta.com/excel/newsgroups/stacked_charts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Alex -

How's this look:

http://peltiertech.com/Excel/Charts/TertiaryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Wendit01]

You can also plot 3 or more Y axes using EZplot or Multy_Y at Office Expander.com

There is a demo version to try.

Cheers.