View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default 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