Creating a Line Graph to Track Progress Using Drop Down Menu Data

[LMCARTER]

Hi all,

I've been working on a workout tracker for the past few weeks, but I'm really having trouble translating my data into a line graph that will help me to track progress over time. I have the data organized by day, body part, and exercise. I would like to be able to pull all instances of a particular selected exercise (cell B3) into a line graph, independent variable being date (A column) and dependent variables being average weight (S column) and average reps (T column). Is this possible? Or is there a better way to do this?

Thanks in advance!

 

[Hui]

LMCarter

Firstly, Welcome to the Chandoo.org forums

How's this ?


See attached file:

A few comments:

1. Avoid Using merged Cells, They look great but stuff up formulas (They have been removed)

2. All your data is based on the date in Cell B18, If that is changed all the dates change. This may mean that you will loose your historical data if it is changed. You are better off to manually enter the dates in each row

3. There is no need to segregate weeks or even days, Just make 1 big table with each entry, The entries don't even need to be in order

 

[Hui]

By changing the dates as described above and then using a simpler formula to extract the data, the workbook has significantly speeded up in performance



This has allowed me to add Conditional Formatting to highlight the common dates

I also added a number of Exercises counter to the table

See what you think in the attached file: