+ Reply to Thread
Results 1 to 11 of 11

Problems with data in scatter line graphs

  1. #1
    Registered User
    Join Date
    05-24-2014
    Posts
    5

    Problems with data in scatter line graphs

    Hi,

    I'm looking at data in relation to July (1-31). I have data for the days 21-31, 22-31 and 25-31. I've inputted my data in the corresponding numbered rows. However, when I go to create my graph (scatter line graph) the data is all offset by a day. So the graph shows 20-30, 21-30 and 24-30, respectively. How can I remedy this? I've attached a screenshot to help explain.

    Many thanks

    Lony

    excel.jpg

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,656

    Re: Problems with data in scatter line graphs

    are you confusing row number of the sheet with data point value?

    Your data starts in row 2 not row 1 of the sheet.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-24-2014
    Posts
    5

    Re: Problems with data in scatter line graphs

    Hi,

    I am sorry but I do not understand what you mean

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,656

    Re: Problems with data in scatter line graphs

    Post example workbook rather than picture.

  5. #5
    Registered User
    Join Date
    05-24-2014
    Posts
    5

    Re: Problems with data in scatter line graphs

    Hi, Do you mean the Excel file?

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    New learning curve! Office 365
    Posts
    25,408

    Re: Problems with data in scatter line graphs

    Yes. That is correct.
    Glenn



  7. #7
    Registered User
    Join Date
    05-24-2014
    Posts
    5

    Re: Problems with data in scatter line graphs

    Thank you - Here it is



    July cholera cases plymouth.xlsx

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    New learning curve! Office 365
    Posts
    25,408

    Re: Problems with data in scatter line graphs

    OK, so what do you want plotted on the X-Axis? I assume that you want days of the month. So, for the Plymouth & Davenport Weekly, what date do you want the first two cases to appear against?

  9. #9
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    New learning curve! Office 365
    Posts
    25,408

    Re: Problems with data in scatter line graphs

    OK, figured it out. I'm a bit slow today. This should be what you want. You hadn't specified the X-axis correctly. If this is OK, please mark the thread as closed & (if I've helped) click the "add reputation" star below my name at the foot of this post.

    If it's not OK, ask again!!
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    05-24-2014
    Posts
    5

    Re: Problems with data in scatter line graphs

    Thank you so very much!
    I really apreciated it

  11. #11
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    New learning curve! Office 365
    Posts
    25,408

    Re: Problems with data in scatter line graphs

    You are very welcome!

+ 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 graphs and horizontal line intercepts
    By Notrealbright in forum Excel - New Users/Basics
    Replies: 20
    Last Post: 10-07-2010, 12:02 AM
  2. How to plot discontinuous/mixed data sets as scatter graphs?
    By Anubeon in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 08-21-2008, 05:13 AM
  3. Line and Scatter chart problems...
    By aboothby in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-26-2006, 09:55 AM
  4. text boxes that label axes in line/scatter graphs
    By Peg in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-09-2006, 04:55 AM
  5. [SOLVED] Scatter Graph - Data Label Problems
    By TBD in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-16-2005, 02:06 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