Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Rosa Campos
 
Posts: n/a
Default 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   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Add more lines and more columns in Excel Marc Charbonneau Excel Worksheet Functions 3 January 20th 05 04:44 AM
BUG?: Excel scatter chart: will not plot x-values Bob Excel Discussion (Misc queries) 2 December 31st 04 01:19 AM
How many data points can you have in an Excel for a Scatter Chart. gregran Charts and Charting in Excel 3 December 10th 04 08:31 PM
Fill area beneath a scatter plot JZip Charts and Charting in Excel 4 December 8th 04 02:59 PM


All times are GMT +1. The time now is 06:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"