three y axes

[Kevin]

I have a chart with two y axes, one on each side, and a single x axis. Is it
possible to construct a chart with three y axes, e.g., units and dollar value
on the left and percent on the right.

Thanks.

 

[Andy Pope]

Hi,

Yes if you build your own chart axes.
Have a read on Jon's page on the subject
http://peltiertech.com/Excel/Charts/TertiaryAxis.html

Cheers
Andy

 

[Jon Peltier]

An easier to interpret option actually separates the data into separate
panels of the chart. This preserves the horizontal alignment of the series
but removes the incorrect impression that the series somehow interact with
each other (which is merely a consequence of how their individual axis
scales were defined).

http://peltiertech.com/Excel/ChartsHowTo/PanelUnevenScales.html

- Jon