S
Stan Brown
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.
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.