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

Asked by JLeslie (65558) July 20th, 2021 from iPhone

I haven’t been feeling well on and off for over a year now. I want to start keeping a food diary and some other measures to see if I find a pattern.

Ideally, I’d like to be able to superimpose two graphs on one. Like make my BP one line and my sodium intake another. See if there is a correlation.

I’m just trying to think through how to number the X and Y axis? If I want the X axis to be the date and I eat three times a day, how would I number that?

I might have multiple graphs and line them up.

The main things I’ll be tracking are: if I feel nauseas, if I have discomfort in my upper abdomen (not nausea, more like a knot), when I ate, my BP, fluid intake, sodium intake.

Any ideas I appreciate it.

Observing members: 0 Composing members: 0

Dutchess_III (46938)

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 (30471)

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

JLeslie (65558)

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.

Dutchess_III (46938)

(Bet I got it backwards!)

Dutchess_III (46938)

@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?

Zaku (30471)

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.

JLeslie (65558)

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

Dutchess_III (46938)

Any luck?

Dutchess_III (46938)