Results 1 to 3 of 3

Thread: Bug in Microsoft Excel Scatter Plot

  1. #1
    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.

  2. #2
    Join Date
    Aug 2011
    Posts
    582

    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.

  3. #3
    Join Date
    Aug 2011
    Posts
    542

    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.

Similar Threads

  1. How to plot XYZ points in Microsoft Excel
    By Genesee in forum MS Office Support
    Replies: 1
    Last Post: 25-02-2012, 10:38 AM
  2. Replies: 2
    Last Post: 25-02-2012, 10:37 AM
  3. How to get multiple XY pairs in Excel 2007 Scatter plot
    By SidharthGore in forum MS Office Support
    Replies: 1
    Last Post: 25-02-2012, 10:30 AM
  4. Need help to plot logistic curve in Microsoft Excel
    By GuruT in forum MS Office Support
    Replies: 2
    Last Post: 03-02-2012, 04:53 PM
  5. Scatter plot in excel
    By Gunner 1 in forum Windows Software
    Replies: 5
    Last Post: 06-01-2010, 01:14 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •