Trying to create chart with multiple time entries for same date

**blandrigan** · 10-09-2012, 09:13 PM

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

**NickyC** · 10-09-2012, 10:35 PM

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?

**blandrigan** · 10-12-2012, 10:03 AM

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?