+ Reply to Thread
Results 1 to 3 of 3

Scatter Plot Missing Values

  1. #1
    Registered User
    Join Date
    08-16-2015
    Location
    Missouri
    MS-Off Ver
    Office Home and Student 2010
    Posts
    2

    Scatter Plot Missing Values

    I am attempting to use a scatter plot with a smooth line on the following data:

    X Y2 Y1
    21.0 2.2 2.2
    21.1 1.5
    21.2 1.3
    21.3 1.3 1.6
    21.4 1.9
    21.5 1.8 2.1

    The curve for Y2 data is correct.

    However, I cannot get the curve for Y1 data to be correct.

    If I specify the Y values for Y1 as a range e.g. $B$1:$B$6 then no plot is created at all. If I specify Y values as discrete points e.g. $B$1, $B$4, $B$6 a plot is created, but the position of the data point 1.3 is placed at 21.1 on the X-axis and data point 1.8 is positioned at 21.2 on the X-axis.

    Any help will be much appreciated. TIA, Joe

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

    Re: Scatter Plot Missing Values

    A sample file might help. I expect that your "hidden and empty cell" setting is set to "gap", which, in a "lines without markers" chart and data like this, will mean not chart.

    I suggest this discussion of handling "gaps" in data. http://peltiertech.com/mind-the-gap-...g-empty-cells/ He discusses the behavior of the different "hidden and empty cell" settings, and other issues that arise when charting empty cells.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    08-16-2015
    Location
    Missouri
    MS-Off Ver
    Office Home and Student 2010
    Posts
    2

    Re: Scatter Plot Missing Values

    Thanks for the reply. You are exactly correct - I went to the Hidden Cell menu & checked 'connect data points with line' and the problem was solved. So many new things to learn!

    Thanks again, Joe

+ 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. Problems with x-values in scatter plot
    By The_Signal in forum Excel General
    Replies: 1
    Last Post: 08-01-2014, 01:32 AM
  2. Scatter plot with intervals instead of single values
    By r-labs in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-14-2013, 07:12 AM
  3. Replies: 2
    Last Post: 07-26-2012, 09:27 AM
  4. Replies: 3
    Last Post: 06-20-2012, 03:28 AM
  5. Scatter Plot with consistent X values
    By samineru in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-27-2012, 04:05 PM
  6. Scatter Plot with Two Sets of Y Values ???
    By malcolm347 in forum Excel General
    Replies: 1
    Last Post: 02-05-2009, 12:44 AM
  7. [SOLVED] I am missing text in my y-axis title for my scatter plot
    By Mackle in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-26-2006, 07:30 PM

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