Line chart with one value extrememly high

[Ed]

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

 

[David Biddulph]

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.

 

[Ed]

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]

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.

 

[Ed]

Thanks for all your help, David.

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.