Can you help me think through how to set up an excel spreadsheet to create some graphs?

Excell graph tutor.

Rows for each date. Columns for number of meals, BP, sodium, nausea, etc.

Then you can select the table and use a graph-creating function in Excel to give you a graph of all the columns automatically.

@Zaku Can I make the date 7.20.01 making 01 breakfast? .02 lunch? So, it will graph all the meals that day?

Here’s an idea. Type numbers 1 thru 9 in A1-A9 across the top.

Then type A, B, C, D, E, F, G,H, I in B2, C3, D4, E5 in the firstcolumn.

Then find your graph feature and start.playing. It’s the best way to learn.

(Bet I got it backwards!)

@JLeslie You could have a different time of day for each meal, though then you’ll need to fill in data for each meal, and you’ll get a different row position for each, and the graph might space them proportionally, to the time value (not sure about that – it may be an option in the graph wizard how you place points on the time axis – spaced per row versus proportional to the time), so if you do want a row for each meal, you might want to either use the actual time of day, or choose times of day for each meal that look how you want on the graph, maybe 6am for breakfast, 12 noon lunch, and 6 pm dinner?

I just realized I might use the actual time instead. Example: 7.20.08.30 or 7.20.13.45.

@Dutchess_III I agree. I need to try it out with some minimal data I guess and see how it works.

It’s fun. Experiment with different graph types. Replace a number with something crazy like 10957 and see what happens.

Any luck?