Excel Spreadsheet/Weight Loss Chart

[SharonA_1970]

Has anyone else done a weight loss spreadsheet and/or chart in excel? I have been entering all my data into a very basic spreadsheet on excel but I can't figure out how to get the chart facility working. Was just wondering if anyone else has done one they would mind sharing?

[Cerulean]

I have done one, but I'm trying to avoid logging into my work IT account whilst I'm recovering. More than happy to clean mine up and make it simpler (I do a lot of manual things in mine each week for predictions and averages)

But all you need to do is select the relevant date and weight cells (hopefully your chart has a date column and your actual weight that week next to one another - if not, just insert a weight column next to the date column and copy the values of your actual WI results to that column or do a simple = formula and drag it down that column) and once you've selected them run the chart wizard and I usually pick the simple line graph - if you want to get clever you can then add in a column for your predicted weight loss each week using a simple ='cellabove'-3 formula and do a two line graph with a comparison against a 3lb a week loss. I'm not altogether sure how I would share an excel file...
but we'll cross that bridge when we come to it!

[Mrs Lard]

Hi Sharon

I think Karion Dieting and Sarah (Cerulean) are fans of Excel (fantastic at dieting and fantasic at database management!!!).

I would LOVE a spreadsheet template...but sadly, am so technically challenged.

In my obsessive way, I would love one that showed AM and PM weights!! Sad, I know but at least I am honest!

Good luck and great suggestion!

Mrs L xxx

[Mrs Lard]

Thanks, Sarah! We posted simultaneously!! Ha ha.
xxxxxx

[SharonA_1970]

Sarah yours would be awesome if you don't mind sharing once you are better. I tried what you suggested but its just making me cross now lol it keeps putting stuff in the wrong place. I even got the manual out and I can't figure out what I am doing wrong. Maybe you could email your file when you get back to work if its not too much trouble?

[Cerulean]

No probs - I have a mac at home so I can't do anything in excel from here - will entertain myself at work tomorrow by cleaning up a template for you!

[SharonA_1970]

Thanks Sarah u are a diamond. Please don't feel there is a rush if you have loads to catch up on just when you get time. BTW hope your mouth is feeling better now, I did feel for you when I saw the swollen picture.

[Cerulean]

I'll be taking it easy at work tomorrow - I'm going in to do some work on - guess what - some graphs - anyway - so I will just go and catch up on my email, do my monthly reports and spend 10 mins making a simple graph spreadsheet for minis - then come home at lunchtime

[KD]

I think Karion Dieting and Sarah (Cerulean) are fans of Excel

Sarah yours would be awesome

LOL.

[SharonA_1970]

lol sorry Karion I didn't mean yours wouldn't be it was just Sarah answered whilst I was still here at the computer

[KD]

No problem Actually, I might email it to you anyway, then you can add both of ours together and get twice the weightloss

[hollycat]

No problem Actually, I might email it to you anyway, then you can add both of ours together and get twice the weightloss

Karion,

I would appreciate it if you could email it to me too.

Thanks in anticipation

[KD]

Karion,

I would appreciate it if you could email it to me too.

Thanks in anticipation

Have pm'd you

[Cerulean]

Karion - LOL at your LOL...

[Ameythist]

I downloaded mine from the microsoft website it has all the columns and graphs and it was free :-)