View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Sandy Sandy is offline
external usenet poster
 
Posts: 355
Default Modify scale in X axis on a scatter plot from Pivot data

I need to increase the gap between my labels on the X axis in a scatter plot.
They are too close and I can not read the labels unless i make them 4pt and
zoom in to 200%. There are about 200 points on the X axis at .2 increments.
I would like to be able to have labels for whole numbers only.

I can not use a fixed set of values by generating a dummy X-axis since the
range changes as I apply the different filters.

Any ideas?

thanks!
Sandy