Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Axis formatting
Excel 2010, Windows 7
I frequently make scatter plots (the first option in the "X Y (Scatter)" row), and I don't understand the automatic formatting of the x axis. My x values typically range from 50 or 60 to 70 or 80, yet very often (not always) Excel jams all the points over at the right edge and starts the x axis at 0, so that the graph is mostly empty space. I've been grumbling at that and setting the axis myself, but it's a nuisance. Is there any way to tell Excel that it shouldn't try to include 0 on the x axis? Here's a sample data set: 67 10 72 12 75 14 74 11 71 12 68 10.5 69 11.5 66 10 70 10.5 66 10 71 12.5 72 13 78 15 73 11.5 66 9.5 64 9 67 10.5 68 11.5 71 12 73 11 77 14 72 11.5 71 10.5 70 12 69 11 The x range is 64 to 78, but Excel chose to set the axis to 0 to 82. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Axis | Charts and Charting in Excel | |||
Formatting X Axis | Charts and Charting in Excel | |||
Formatting Axis | Excel Programming | |||
Formatting X and Y axis' | Charts and Charting in Excel | |||
Formatting of x axis | Excel Discussion (Misc queries) |