+ Reply to Thread
Results 1 to 4 of 4

Comparative Weight Loss track chart

  1. #1
    Registered User
    Join Date
    04-22-2009
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    2

    Comparative Weight Loss track chart

    Hello people,

    I am struggling to create a chart and was wondering whether you could help me on this. Basically, we have started a diet with my friends and the 5 of us in total would like to see a chart where we could see the progress of our weight loss. Is that something possible? I was hoping to have showing vertically the weight 'scale' and horizontally the days. My friends would give me their weighings each week, so that by the end of the 6 months whatever we can see hopefully, let's say person 1 in pink, with a line showing she had lost a certain amount of weight, person 2 in blue, and etc.. Is that do-able in excel?

    thank you for whatever help you can give me

    p.s i am familiar with excel, quite good in general with computer things but terrible with maths, and i dont understand the term axis and other technical stuff like that

  2. #2
    Registered User
    Join Date
    04-22-2009
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Comparative Weight Loss track chart

    Hi,

    How about this. I have used a pivot chart. The index button on the top with figure 1 correlates to person 1, 2 to person 2 etc.
    hope this does the trick

    Cheers

    Bob
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-22-2009
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Comparative Weight Loss track chart

    Hi Bob,

    Aww thank you for your reply and for taking the time to work on this.
    This is really helpful. Ideally though, I had a kind of chart like this (I have attached a rough picture) in mind, but will deffo use yours in the meantime
    xx thank you
    Attached Images Attached Images

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Comparative Weight Loss track chart

    You just need to create a line chart.

    I have include a actual weight and weight loss set of data.

    You might want to turn the data layout around so days go down the rows.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1