I want to have the ability to track my workouts by recording results in a spreadsheet.

I want to be able to graph (pivotchart) my progress over time. An example of a workout may be:

• Bench Press - 3 sets of 10 reps each.
• Squat - 3 sets of 12 reps each
• Barbell row - 5 sets of 6 each

That's just an example for the sake of illustrating my problem.

How should I go about tracking the sets and reps and then what I did? Maybe I'm supposed to do 135 pounds on the bench press but I only end up being able to do 7 reps on the third set.

What I want to track would be the sets, reps, the weight I used, the actual number of sets and reps I did and the date so I know when I did them. I would then like to be able to have a table that shows what I did last time so I can decide what I should try to do next time.

How should I design these rows and columns to be able to capture that data and then use it for reporting?