View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 3 values on Y axes

Joe -

You have (at least) three options:

* Make three different charts

* Make one chart with primary, secondary, and tertiary axes. Excel doesn't
come with tertiary axes, but that's never stopped me:

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

* Make one chart, with each series (or set of series) plotted within its own
region of the chart. This is the trickiest since you have to jury-rig three
axes, not just one as in the Tertiary Axis option.

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

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


"Joe W" wrote in message
...
I have 3 widely varying values that I'm trying to plot. I have 2 Y axes
(which take care of 2 values). The third value is well outside the ranges
of
the other 2 and its fluctuations are too difficult to decipher. Is there
a
solution for this? It's as if I'm trying to create a 3rd Y axis! BTW,
I'm
using a line graph; the X axis is a date range.
--
Thanks,
Joe