Modify scale for lables on the X-axis of a scatter plot from Pivo

S

Sandy

Modify scale for lables on the X-axis of 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify scale in X axis on a scatter plot from Pivot data 1
x-axis scaling 5
Excel 2007: Lines not displayed on Scatter Plot 0
Replace numbers on x-axis of scatter chart with text eg 1 - one 3
Scatter plot with two data series having common x-values 2
xy scatter with date/time as x axis 2
Secondary X-Axis on Scatter Plot 0
time scale-x with scattered data-y 1

Top