Ready, steady… save!
You don’t need a chart to join in. Here are 2 ways to record your savings:
1. Cross it off
Pop a chart into your first post. Saved an amount? Cross it out! Read more »
£0.01 £0.02 £0.03
2. Write it down
Skip the chart and add updates to your first post. Read more »
“Another +£3 saved today. Go me!”
Use +£ before each new saving so it counts towards your total.
📨 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
Ms_Chocaholic
Posts: 13,996
Forumite
in Techie Stuff
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
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
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
0
Comments
-
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
0 -
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?
Charlie0 -
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)?0
-
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
HTH0 -
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 time0 -
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?Charlie0
-
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 time0 -
Like this?

Basically the same as before, but with two less sets of data.Charlie0 -
That's brill, thanks x Now just to start the runningThrifty 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 time0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
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