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?

Ed

"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.
--
David Biddulph

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.

Ed

"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.
--
David Biddulph

"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

Thanks for all your help, David.

"David Biddulph" wrote in message
...
"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