Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Modify scale for lables on the X-axis of a scatter plot from Pivo
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Modify scale for lables on the X-axis of a scatter plot from Pivo
I have the same problem, except I'm using a line chart. Does anyone have any
suggestions on how to increase the space between the x-axis category lables? Thanks! "Sandy" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify scale in X axis on a scatter plot from Pivot data | Charts and Charting in Excel | |||
xy scatter chart-How can you make the axis equal for a 1H:1V plot | Charts and Charting in Excel | |||
Scale on X & Y Axis of the scatter chart | Charts and Charting in Excel | |||
X axis scale on an XY scatter plot | Charts and Charting in Excel | |||
Locking the scale ratio of X-Y axis in XY scatter charts | Charts and Charting in Excel |