Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have a scatter plot, and have set the y-axis to cross the x-axis at the
average x-axis value. I want the y-axis to always be in the centre of the scatter plot (i.e the x-axis range). However, my x-axis values may range from -13,294 to 14,000, with axis values in between of -7,836, -2,377, 3,082 and 8,541. I want to keep the range I have, but force x-axis values shown to be rounded numbers, for example labels at -10,000, -5,000, 5000, 10000. All help greatly appreciated. Graham |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data labels along below x axis when y axis has negative values | Charts and Charting in Excel | |||
How do I reference x-axis or y-axis scale values to a worksheet ce | Excel Discussion (Misc queries) | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
How do I change X-Axis values in a chart with 2 Y-Axis? | Charts and Charting in Excel | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel |