📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Simple (I Think) Spreadsheet Help

My diet/fitness drive starts tomrorow (08.01.12); I did the same last year and lost over 2 stones. I run on the treadmill but got bored of writing down the results of each session (ie distance and time and average speed (in km)) as they were nothing but pages of figures on a sheet and showed nothing.

I thought this year I would do a spreadsheet to record these three things and hopefully it will come up with a chart (hoping) that will show how i'm progressing and give me the motivation to continue.

The thing is, I haven't the first idea of how to do it. I've googled to find similar but the ones I've found are way too detailed, can anyone help.

Thanks
Ms Choc x
Thrifty Till 50 Then Spend Till the End
You can please some of the people some of the time, all of the people some of the time, some of the people all of the time but you can never please all of the people all of the time

Comments

  • macman
    macman Posts: 53,129
    Part of the Furniture 10,000 Posts Name Dropper
    Forumite
    All spreadsheet programs have the ability to produce simple graphs and charts, suggest you consult the Help menu for your particular software.
    No free lunch, and no free laptop ;)
  • f1charlie
    f1charlie Posts: 1,228 Forumite
    Enter data in columns, select all data including headings with your mouse and select insert chart. Excel 2010 shown below. Which program are you using?

    excel.jpg
    Charlie
  • googler
    googler Posts: 16,103
    Part of the Furniture 10,000 Posts Name Dropper Combo Breaker
    Forumite
    So you want simple line chart, with one line or trace for each parameter of distance, time and average speed (on the vertical axis) against calendar time (horizontal axis)?
  • Linbox
    Linbox Posts: 383 Forumite
    edited 9 January 2012 at 8:25PM
    Ive uploaded my old walking/running spreadsheet to
    http://www.mediafire.com/?22614f35gkmgfnk


    Please take a look

    Just put in the distance and time taken - it'll work out the rest. I get the distance from the mapping link included in the January sheet.
    It has monthly and yearly charts for all the details.

    I also have weight & BMI log spread sheet if you want

    HTH
  • Ms_Chocaholic
    Ms_Chocaholic Posts: 13,996
    Part of the Furniture 10,000 Posts Name Dropper
    Forumite
    Thanks for your help. I've just been playing about as per f1charlie's diagram and using my version of Excel (2003) I can get a similar chart. Having given this some further thought though, I wonder if it is possible for the chart to display one set of results, for example, say I run 5k in 35 mins today but then ran 5k in 32 minutes tomorrow, then the same 5k in 31 minutes, then I was having a bad day and it took me 45 mins to run 5k, is there a way to plot that on a chart as one item.

    I hope that makes sense.

    PS There is no way on this earth I can run 5k, I just gave that as an example (it made me sound good ha ha) :-)
    Thrifty Till 50 Then Spend Till the End
    You can please some of the people some of the time, all of the people some of the time, some of the people all of the time but you can never please all of the people all of the time
  • f1charlie
    f1charlie Posts: 1,228 Forumite
    Do you mean just one line showing the time taken to walk 5km? Just have 1st column as the date, 2nd column as the time taken and create chart as before - or have I got the wrong end of the stick?
    Charlie
  • Ms_Chocaholic
    Ms_Chocaholic Posts: 13,996
    Part of the Furniture 10,000 Posts Name Dropper
    Forumite
    Thanks for taking the time to reply.

    Yes just one line showing the time taken to do whatever distance I've done that day - what I want (if I can) is a graph showing one line of how long it took me to run 5k - basically it's to be able to chart my progress, so in a month's time I can look back and say, wow, look how much better I am now than when I started and hopefully that will give me the motivation I need to continue.
    Thrifty Till 50 Then Spend Till the End
    You can please some of the people some of the time, all of the people some of the time, some of the people all of the time but you can never please all of the people all of the time
  • f1charlie
    f1charlie Posts: 1,228 Forumite
    Like this?

    2012-01-09_225141.jpg

    Basically the same as before, but with two less sets of data.
    Charlie
  • Ms_Chocaholic
    Ms_Chocaholic Posts: 13,996
    Part of the Furniture 10,000 Posts Name Dropper
    Forumite
    That's brill, thanks x Now just to start the running
    Thrifty Till 50 Then Spend Till the End
    You can please some of the people some of the time, all of the people some of the time, some of the people all of the time but you can never please all of the people all of the time
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 356K Banking & Borrowing
  • 255K Reduce Debt & Boost Income
  • 456.3K Spending & Discounts
  • 248.5K Work, Benefits & Business
  • 606.2K Mortgages, Homes & Bills
  • 179.1K Life & Family
  • 264K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.7K Read-Only Boards
Quick Search

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.