+ Reply to Thread
Results 1 to 3 of 3

XValue Data Points Not Plotting Correct Values

  1. #1
    Registered User
    Join Date
    08-24-2009
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    2

    XValue Data Points Not Plotting Correct Values

    I'm working on creating an XY-Scatter plot using index to find the correct X and Y values. The Y values plot perfectly fine, yet my X values seem to be using [1,2,3,4,5..] instead of the actual values.

    I read the post about the bug in SP1 but this is SP2. I'm not all that great with excel and seem to have exhausted my options on figuring this out. Any help would be GREATLY appreciated.. I really wouldn't be surprised if it were something small I'm overlooking.

    The sheet in question is Sheet 3 on the attached spreadsheet.
    Attached Files Attached Files
    Last edited by shephejm; 08-24-2009 at 08:47 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    08-23-2009
    Location
    Hampshire, UK
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    328

    Re: XValue Data Points Not Plotting Correct Values

    The correct values are plotted if you change the chart source range to include only the cells which contain numbers. I've added two dynamic ranges XPlot & YPlot to do this. You can see the formula for these in Name Manager.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-24-2009
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: XValue Data Points Not Plotting Correct Values

    Thank you so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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