Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Bug in Microsoft Excel Scatter Plot

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 03-02-2012
Member
 
Join Date: Jan 2012
Posts: 64
Bug in Microsoft Excel Scatter Plot

I am trying to make a simple scatter plot. There are two columns of data. Excel will not plot values on the x- axis, only categories. I have entered the ranges for x and y values correctly, and the chart wizard shows it; yet, the chart comes out with the x-axis showing only the points numbered in the order they are entered in the spreadsheet. Oddly enough, if only one y-value is included, it plots properly; the x-axis correctly shows the range of x-values entered, and the single data point shows up at its proper xy location. as soon as I expand the y-range to more points, the x-axis reverts to categories, and can't be fixed. I think this is a bug. How so I fix it. Thanks.

Reply With Quote
  #2  
Old 03-02-2012
Member
 
Join Date: Aug 2011
Posts: 576
Re: Bug in Microsoft Excel Scatter Plot

Ensure that this is in fact an xy chart: With the chart selected, Chart - Chart Type. If so, look at Chart - Source Data, Series tab: Ensure there that the x and y cell references are what you want. Still failing? Remove formatting from your x and y cells (Format - Cells - Number - General). What do you see there.
Reply With Quote
  #3  
Old 03-02-2012
Member
 
Join Date: Aug 2011
Posts: 539
Re: Bug in Microsoft Excel Scatter Plot

There are two things that you can check. First be sure the chart type is XY (Scatter). Second just be sure all data values are numeric, not text. If even one is non-numeric, the XY (Scatter) chart will revert to Line (category labels on the horizontal axis). To fix, enter 0 (zero) in a cell, copy the cell, select the cells containing the chart data, and choose Edit > Paste Special > Add.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Bug in Microsoft Excel Scatter Plot"
Thread Thread Starter Forum Replies Last Post
How to plot XYZ points in Microsoft Excel Genesee MS Office Support 1 25-02-2012 10:38 AM
How to point label in Excel scatter plot with text associated to it Kanshin MS Office Support 2 25-02-2012 10:37 AM
How to get multiple XY pairs in Excel 2007 Scatter plot SidharthGore MS Office Support 1 25-02-2012 10:30 AM
Need help to plot logistic curve in Microsoft Excel GuruT MS Office Support 2 03-02-2012 04:53 PM
Scatter plot in excel Gunner 1 Windows Software 5 06-01-2010 01:14 PM


All times are GMT +5.5. The time now is 11:24 PM.