Peak Flow chart

Hello

I am relatively new to excel, and most of what I already know, I have picked up by trial and error.

as an asthma sufferer, I thought a good project to work on to practice using excel, would be creating a peak flow chart. I'm not really sure how I would go about it, still being a new user and all.

any advice in how to go about creating this would be appreciated.

I haven't got any data other than the results from the peak flow test when I take it.

I take the test twice a day, first thing at morning, and last thing at night, by blowing into a peak flow meter. the markings on the side of the meter go from 60-800.

this is sort of what I am after, but I would like to learn how to make it myself.

http://office.microsoft.com/en-us/te...030003204.aspx

If I were creating such a chart:

1) Put your data into two columns: 1st column to contain the test date/time, 2nd column will contain the corresponding test result.

2) Select the data columns, then click Insert -> Chart to bring up the chart wizard

3) Select the desired chart type. I'd use either a line chart or a scatter plot, depending on whether I wanted to treat the test date/time as a number (scatter plot) or a category (line chart). I'd probably do a line chart in this case.

4) Finish out the wizard and see if it looks like what you want.

I tried to load the file, but it says it contains errors, then when I try to close it, it freezes excel.

Originally Posted by mrice

Please see the attached.

I've changed the chart type to a scatter plot and introduced an additional column which converts the AM/PM into a fraction of a day.

I appreciate the help, but that is kind of taking the chart away from what I am after and moving it in another direction. maybe at some point I will give that a try though, so thanks.

I have been making a bit more headway, mostly by trial and error, but it seems that when I overcome one hurdle, I manage to come across another.

I have got the chart pretty much fixed, but I am struggling to find out how to fix an issue with the lines on the chart itself.

this is an image of what I am referring to

http://imageshack.us/photo/my-images/851/previewdi.jpg/

as you can see, after the last point is plotted on the chart, another line is automatically being drawn to zero on the following entry column. how do I configure the line to end at the last point?