I have a .csv of my blood sugar levels over time from the GLUCOFACTS application. I've imported it into Excel 2013 with the intention of making a visual chart of my data to my doctor. Unfortunately I'm completely stumped as to how to make it.
I'd like to make a scatter graph where the vertical axis is the blood sugar level and the horizontal is the combination of the date and time. The times aren't spaced equally (9:39, 11:44, etc) and I don't want them spaced equally on the graph. I'd like the horizontal axis to be an hour per tick and the times would fall between or on the ticks.
Date and time and blood sugar are on separate columns.
I've google for examples I can't find any that aren't outdated. For extra difficulty I'm working with the French version of Excel.
How do I do this?