Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Scatter Plot with connected by smooth lines
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!!! |
#2
|
|||
|
|||
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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Add more lines and more columns in Excel | Excel Worksheet Functions | |||
BUG?: Excel scatter chart: will not plot x-values | Excel Discussion (Misc queries) | |||
How many data points can you have in an Excel for a Scatter Chart. | Charts and Charting in Excel | |||
Fill area beneath a scatter plot | Charts and Charting in Excel |