View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Neil Neil is offline
external usenet poster
 
Posts: 173
Default Pivot Chart Y Axis

Hello

I have a Pivot table with 4 different kinds of data on. Two sets of the data
are in the 500-900 range and the other two are 5-10 range and 30-50 range. I
have these set as a line chart so i can can compare the data over differnet
weeks. But with this weighting it makes the lower value ranges harder to see
clearly. Is there a way i can change the Y Axis to ditch say 200-400 and
bring tham closer together.

I Hope this makes sense

Thanks