View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
 
Posts: 563
Default Chart with un even data

Right click one data series on the chart and select Format Data Series
Depending on what version of Excel you are using there will be an option
somewhere to use a secondary axis for this data series.
The secondary axis will be on the right-hand side of the chart and will
automatically get a suitable (or near suitable) scale.
best wishes
Bernard

"Abdul" wrote in message
...
Hi Bernard,

Could you please explain further from the above examle data.

thanks