+ Reply to Thread
Results 1 to 4 of 4

Trying to create chart with multiple time entries for same date

  1. #1
    Registered User
    Join Date
    10-09-2012
    Location
    Merrimack, nh
    MS-Off Ver
    Excel 2010
    Posts
    2

    Trying to create chart with multiple time entries for same date

    Apologies in advance if this is posted someplace else. I have a spreadsheet with blood sugar data (my daughter is diabetic). The spreadsheet is a CSV download from her monitor. If she tests 4 times in one day the entries are shown as four separate rows with the same date but obviously different times of day and the corresponding blood sugar count for that time. When I try to chart it, all 4 data points from that one day show in a stack instead of as 4 separate items. How do I change this? Thanks much..bl

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Trying to create chart with multiple time entries for same date

    Hi
    using an xy scatter chart type with lines should do this for you
    you'll need to set the x-axis values according to the dates and times you want to show
    do you want to track several days' data as one line, just one day's data, or several days' data as different lines?

  3. #3
    Registered User
    Join Date
    10-09-2012
    Location
    Merrimack, nh
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Trying to create chart with multiple time entries for same date

    Thanks for the reply....I want to track several days data on a single line. But the 4 entries for October 7 for example, all stack on one vertical line even though they are time stamped differently. How do I get the 4 entries strung along a horizontal axis?

  4. #4
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Trying to create chart with multiple time entries for same date

    Hi
    if you upload a copy of your workbook I'll take a look

+ 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