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