+ Reply to Thread
Results 1 to 2 of 2

Y axis data appears as 0 in scatter plot

  1. #1
    Registered User
    Join Date
    02-22-2020
    Location
    Flagstaff, Az
    MS-Off Ver
    Office 365
    Posts
    1

    Y axis data appears as 0 in scatter plot

    It seems to be a scaling issue but I cant get the data to display properly in the scatter plot, it should look like a curve but no matter what I do it just shows up as a bunch of dots along the x axis. In the sheet labeled "brass".
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Y axis data appears as 0 in scatter plot

    It appears that all of the values in column B are numbers stored as text. In a scatter chart, Excel treats text entries -- including numbers stored as text -- as the value 0. Solution is to convert you numbers stored as text to real numbers. A few strategies are given here: https://support.office.com/en-us/art...1-c5bad0f0a885
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Scatter plot x-axis showing data as categories instead of values
    By Randolph123 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-22-2016, 04:35 AM
  2. Scatter plot x-axis problem
    By shka_life in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-29-2016, 06:48 AM
  3. Scatter plot x-axis problem
    By shka_life in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-26-2016, 03:02 PM
  4. Scatter plot with two X axis data
    By hityou123 in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 02-02-2015, 08:26 PM
  5. Excel won't use my data on the x-axis of a scatter plot
    By Sabina in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-12-2012, 06:55 AM
  6. Excel 2007 : Scatter Plot-Changing the X-axis HELP!
    By Pacinterp in forum Excel General
    Replies: 1
    Last Post: 04-07-2011, 04:11 AM
  7. [SOLVED] X axis scale on an XY scatter plot
    By Tim in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-21-2006, 08:55 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1