Excel Scatter Plot with connected by smooth lines

[Rosa Campos]

It is not honoring my numbers for the X-Axis, they go from -1300 to 3200, on
the graph it's going from -8900 to -8200, but when i go to the source data my
numbers for the X-Axis are selected how do i change this? Its urgent!!!

[Jerry W. Lewis]

Double click on the x axis and on the Scale tab manually select minimum
and maximum for the scale.

If you inserted the graph, instead of changing data on an existing
graph, then there is something else going on, since by default Excel
will encompass the entire range.

You might also select the chart and on the menu select Chat|Chart type
to ensure that you have an "XY (Scatter)" chart and not a "Line" chart.

"Line" chart is a misleading name; it has nothing to do with whether you
connect by lines or not, and everything with how the x-axis is
interpreted. A "Line" chart will equally space all observations, even
if you supply x-values that are not equally spaced. X-values (if
provided) are merely labels on a "Line" chart, not scaled values.

Jerry

Rosa Campos wrote:

> It is not honoring my numbers for the X-Axis, they go from -1300 to 3200, on
> the graph it's going from -8900 to -8200, but when i go to the source data my
> numbers for the X-Axis are selected how do i change this? Its urgent!!!