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

Pivot charts don't let you change the spacing of the categories. They also
don't let you make an XY (scatter) chart, so you probably have a line chart.
In a regular line chart you can double click the X axis, and on the Scale
tab, enter larger values for Number of Categories between Tick Marks/Tick
Mark Labels.

You can make a regular chart from pivot data. Select a blank chart not
touching the pivot table, and create a chart. In step 2 of the wizard, click
on the Series tab, and enter data for the series one-by-one. If you use the
Data Range tab, the chart will instantly convert to a less flexible pivot
chart.

To adjust to changing pivots, you will need to make a dynamic range that
includes the column of values being plotted. Here are some dynamic chart
examples and links to many mo

http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Sandy" wrote in message
...
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