Line chart with one value extrememly high
 

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

Line chart with one value extrememly high
 

"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

Line chart with one value extrememly high
 

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

Line chart with one value extrememly high
 

"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

Line chart with one value extrememly high
 

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