How to Use Google Docs to Track and Display Your Weight Loss

Here’s a My weight loss progressgreat way to create a spreadsheet tool using Google Docs, that tracks your weight loss progress that also allows you to share your progress with your blog readers in a nifty little chart that looks like the image to the right ->

Things You’ll Need:

  • A computer connected to the internet
  • A free Google account

Instructions:

  1. Go to the Google home page
    Before creating your weight loss tracking spreadsheet using Google Docs, you must Sign In to your Googe account. To do that go to Google.com using your internet browser. On the Google home page click on the “Sign In” in the upper right corner of the web page.
  2. Sign into your free Google account
    On the Google Accounts sign in web page, log into your free Google account by entering your account email address and password.
  3. Navigate to the Google Docs web page
    After signing into your Google account, click on the “more” link at the top of the page, and then click on “Documents”.
  4. Create a blank spreadsheet
    To create a blank spreadsheet, on the navigation bar click on “New” and select “Spreadsheet”.
  5. Enter the headings into your weight loss tracking spreadsheet
    Enter the headings of your weight loss tracking spreadsheet into row 1. Type in these cells:-A1: Date
    -B1: Weight
  6. Enter dates into your weight loss tracking spreadsheet in column A.
    I choose to only weigh myself once a week, on Monday mornings.  My column A has the following dates:2/1/2010
    2/8/2010
    2/15/2010
    2/22/2010
    3/1/2010
  7. Enter your weight in column B.
  8. Click “Insert”, then select “Chart” to begin creating your chart.
    chart1 188x120 How to Use Google Docs to Track and Display Your Weight Loss
  9. A new chart window will pop up. Select chart type of your choice:
    chart2 236x120 How to Use Google Docs to Track and Display Your Weight Loss
  10. In the “What data” field enter: Sheet1!A1:B11
  11. Group data by columns, and tick off the two selection boxes:
    chart4 236x120 How to Use Google Docs to Track and Display Your Weight Loss
  12. Add a title to your chart and axis names – I have given my axis the names “Date” and “Weight”:
    chart5 236x120 How to Use Google Docs to Track and Display Your Weight Loss
  13. Save your chart!
  14. Click on your newly created chart and scroll to “Publish chart”
    chart6 165x120 How to Use Google Docs to Track and Display Your Weight Loss
  15. Copy and paste the resulting HTML code where ever you would like to publish your new weight loss chart.
    chart7 164x120 How to Use Google Docs to Track and Display Your Weight Loss
    Some examples are:

    • Your blog sidebar
    • Blog post
    • Page on your blog (I have a progress page where you can follow my weightloss and half marathon training progress).
  16. Be sure to save your spreadsheet by clicking on the “Save” button at top of the web page.
  17. Visit your spreadsheet each week and enter your weight – your chart will automatically update.
Reblog this post [with Zemanta]

Fitness Tip of The Day: Make a list of all the benefits regular exercise provides you. Everything from feeling healthier, sleeping better, preventing depression, feeling stronger, etc. Post this list somewhere that you will easily see it everyday so that it can serve as a reminder why you should workout.



Related Websites:
  • Acai Berry SelectTop Four Weight Loss Pills Top Four Weight Loss Pills Comparison Amongst all diet pills, we believe Acai Select, Proactol, Pure Acai Berry, and Phen375 are the best for weight loss. However, it is always hard for consumers to know which solution works for them. That's the reason why we compare these top four......

  • chunkysoupWeight Loss Secrets pt 4 The right weight loss secrets can go really far in helping you achieve the healthful and natural weight loss that you are looking for. Here are some healthy and natural weight loss secrets. Weight Loss Secret #1 - Reflect on all of the choices that you make. When you look......



Subscribe / Share

Article by Janice - The Fitness Cheerleader

Janice Smith, B.Sc (Kin), ATTH obtained her Bachelor of Science in Kinesiology and her Certificate in Athletic Therapy from York University in Toronto, ON Canada. She has an extensive background treating the injuries of athletes having worked with the York University Football, Volleyball and Water Polo teams. She is an avid runner–running several full and half marathons in addition to completing several triathlons. She has coached several “learn-to-run”, 10K and half-marathon clinics. She works full-time and she is a mom of two dynamic little girls. Janice - The Fitness Cheerleader tagged this post with: , , , , , , , , , , Read 140 articles by Janice - The Fitness Cheerleader
3 Comments Post a Comment
  1. 1

    [...] How to Use Google Docs to Track and Display Your Weight Loss [...]

  2. 2

    [...] (btw-here’s instructions on how you can create one of these charts for yourself) [...]

  3. 3
    Tracy says:

    Thanks so much for the tip. I have a Progress page of my own now….very simple! I never thought of using Google docs for this. :-)

Leave a Reply




CommentLuv Enabled

Sign Up for My Newsletter & Qualify For Monthly Giveaways

(Newsletters are only sent once a week)

send me email about...



A prize will be awarded to 1 random subscriber each month!

The September prize is: The Fitness Cheerleaders Walk & Tone mp3! Melt the pounds away and discover a leaner, stronger you with this 40 minute walking mp3!

This blog is PR Friendly Google PageRank Checker

Shopping Cart

Your cart is empty

Fitness Cheerleader’s Walk & Tone mp3 Workout


Melt the pounds away and discover a leaner, stronger you with this 40 minute walking mp3!

Upload this walking workout to your iPod or other mp3 device to increase the intensity of your walk and burn more calories by doing an upper body workout with your hand weights.

ON SALE FOR $1.99 - USE COUPON CODE: LAUNCH

Fitness Tip of The Day

Stretching and flexiblity are very important aspects of good physical fitness, so don't overlook them. Ideally, you should stretch before each workout (both cardio and resistance exercises) and after each workout. If you can't do both, then make the after stretching a priority.

Like Me!

Sponsors

Sites I Love

Mamavation



Apple Seed Maternity Clothes
fitmomintraining.com
Running Rachel

Grab My Button



Take the Inner Mean Girl 40-Day Cleanse


My Training Progress