Guides › A calmer weight chart for GLP-1 treatment: weekly averages in Google Sheets · Updated 30 Oct 2026

A calmer weight chart for GLP-1 treatment: weekly averages in Google Sheets

This guide is about keeping records, not medical advice. Your dose, schedule and injection technique are set by your prescriber and the patient leaflet; bring questions to them.

Daily weight goes up and down with water, salt and the time of day. If you look at single numbers you will worry for nothing. A weekly average smooths that out.

The data

Two columns: Date in A and Weight in B, one row per weigh-in. Weigh at the same moment each day if you can, for example after waking up.

The 7-day average

In C8 (the seventh row of data):

=AVERAGE(B2:B8)

Copy it down. Each cell now shows the average of the last seven entries. If you skip days, use a date-based version instead:

=AVERAGEIFS(B:B, A:A, ">"&A8-7, A:A, "<="&A8)

The chart

Select A, B and C and insert a line chart. Make the daily weight a light grey line or dots, and the average a thicker coloured line. Your eye will follow the thick line, which is the point.

Change since start

=INDEX(C8:C1000, COUNT(C8:C1000)) - C8

That is the latest 7-day average minus the first one. Use averages, not single days, for both ends.

Measurements

Many people add waist and hip measurements every two or four weeks. They often move when the scale doesn't. Keep them on the same sheet with their own date column.

Rather start with a ready-made file?

The GLP-1 Tracker already has weight and measurement charts, in kg or lb, alongside the dose log and a summary you can show your doctor. Your data stays in your own file.