Modify scale in X axis on a scatter plot from Pivot data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sandy - 10 Oct 2006 16:44 GMT

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

Reply to this Message

Jon Peltier - 13 Oct 2006 03:28 GMT

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 more:

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

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

>I need to increase the gap between my labels on the X axis in a scatter
>plot.
[quoted text clipped - 11 lines]
> thanks!
> Sandy

Reply to this Message