Thread: Exercise Log: Plot Non-Zero Elements

Hey all,

I've got an interesting question. I want to plot the weight and reps of each exercise in my spreadsheet vs. date and set, but not all exercises have the same number of sets. So, looking at my spread, I want to plot only the non-blank sets of each exercise. I can't seem to find a way to make a function that filters out the blank cells, and also only plots the used dates and sets on the x-axis for each exercise. I've thrown in some sample data on the "Day 1" worksheet in an attempt to show my question. I hope I've been clear enough; it's getting late, and I'm getting tired!

Thanks!
Richard D. Reavis

You might want to consider your data layout.
Revising it and using a pivot chart may save a look of heartache.