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