Charts - Multiple Y-Axis

[Guest]

I know how to set up a scatter chart with two Y-axis....

Is there some way to set it up with three or more, preferably on the left
side of the page???

 

[Jon Peltier]

You can fake it, and it will add more clutter than the extra axes will clear
up, but here's a tutorial:

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

A better option is to make a panel chart, with each series in a separate
panel with its own axis:

http://peltiertech.com/Excel/Charts/StackedCharts.html
http://peltiertech.com/Excel/Commentary/BirthsByDayOfYear.html

- Jon

 

[inquiry]

I know how to set up a scatter chart with twoY-axis....

Is there some way to set it up with three or more, preferably on the left
side of the page???

To create three of more axes on the left of a chart, try Multy_Y for
Excel at www.OfficeExpander.com. There is a free demo version too.
For advanced multiple Y plots, try EZplot (which also has a demo
version).

Cheers.