View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default Scaling within a chart

Yes, right-click one of the series, Format Data Series/ Axis / and select
secondary axis.
--
David Biddulph

"Oliver S" wrote in message
...
I have 3 series of data; 1. A total figure (1500-2500) and two series of
percentages (0-100%).

I would like to show them all on the one chart but the scale sits far too
hight to see the percentages and they just look like straight lines. Is
it
possible to have two different types of figures that are numerically far
apart scaled down to assist in reading? Any help would be appreciated.