"Ed" wrote in message
...
"David Biddulph" wrote in message
...
"Ed" wrote in message
...
I need to create a line chart on vehicle testing. The chart includes
several temperatures and pressures - and engine RPM. We stepped the RPM
up and down a few times to see the effects on the other data points. If
I put all of this on a chart using the wizard, the RPM values go so high,
everything else is reduced to nearly flat lines at the bottom of the
chart.

It's almost like I need a second chart on a different scale superimposed
over this one. Or possibly a way to hash the background into different
color vertical stripes to delineate the RPM ranges. How can I show
these RPM values in line with the other data lines so the reader can
correlate RPM changes with other changes?

Select your RPM series, then Format Data Series/ Y-axis,
and select secondary axis.

Thanks, David. That's a great trick! One more thing, if you would - the
left Y-axis extends from -50 to 350, the right Y-axis extends from 0 to
3000. Is there any way I can get the 0-lines to match? There are no
negative numbers in the data series.

Yes, select each Y axis as required, Format Axis, then you can set the
minimum Y value for each series to zero, if that's what you want, or to
whatever other value you prefer.
--
David Biddulph