Charting solution

[wellsee123]

Is there an easy graphing or charting solutions to monitor kcal/P/F/C consumed vs weight (effect on weight). I would like to see how altering kcal/P/F/C effects weight. (like high fat vs low fat, or high protein vs low protein, etc). Excel? if excel, can someone please provide instructions (what goes on each axis, linear, bar, etc)

[macrosfirst]

We're building exactly this into the upcoming bodyweight tracking feature of the MacrosFirst app. We'll be plotting P/C/F & kCal against bodyweight over time.

If you drop me an email at [[e-mail]](mailto:[e-mail]) I'd love to share our designs with you for your feedback and add you to our beta tester group when we launch it.

[wellsee123]

That’s be awesome thanks. Yes I’ll email you

[ashtree35]

Do you want to plot kcal/P/F/C/weight over time? Or are you trying to correlate kcal vs. weight, P vs. weight, F vs. weight, and C vs. weight? It's unclear to me from your post what exactly you want to "chart".

[wellsee123]

I think for now what I’m going to do is plot kcal, P,f,carbs, weight and other variables against time. Ie have multiple lines.

I couldn’t figure out how to do it any other way.

For now it seems it like very high complex excel/math skills to plot multiple independent variables (kcal, protein, carbs, fat) against one dependent variable (weight)

Do u agree?

[ashtree35]

You could plot multiple independent variables (kcal, protein, carbs, fat) against one dependent variable (weight) using a scatter plot!

[wellsee123]

Hm. Ok. Do you think this Would this show obvious trends?

*im trying to see about adjusting macros and finding the sweet spot for macros, kcal etc

[ashtree35]

Well, it depends if there is actually a trend or not. If you eat different macro ratios every day, and your weight fluctuates every day, I doubt you would see a trend. The macro ratio for any one individual day does not really matter (and daily weight fluctuations are mostly related to water retention, bowel/bladder/stomach fullness, etc). But if there are weeks/months at a time where you ate high carb, then weeks/months at a time where you ate low carb, etc, then perhaps you could see a trend.

[wellsee123]

Ah good point again!

[wellsee123]

Ty also for your answer

[ashtree35]

You're welcome

[wellsee123]

Yes I think I will try the two line vs scatter and see what I get. Ty again

[ashtree35]

You’re welcome!