Thread: Axis values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Sri Harsha[_2_] Sri Harsha[_2_] is offline
external usenet poster
 
Posts: 24
Default Axis values

Hi,
I am trying to generate a chart through a pivot table and by default, it is
taking 20% difference in vertical values data in the axis like 0%, 20%, 40%
etc. If my value is 87.50%, the marker is pointed above 100%. This happened
to only "Stacked line with markers" and it took 10% difference in values for
other ones and they look fine. How do have excel change the values it takes?