I asked this question in a workout thread, but maybe I’ll have better luck here.
I have been putting together an Excel workbook to track my workouts, and make pretty graphs. I’ve hacked some Basic scripts up to make a data dump worksheet, and that is working all right, but when it comes to the graphing I am stuck. Here is what i would like it to do:
Update the graph when I add a column to the data dump sheet.
Draw lines between data points in the same series even if there is a point missing between them.
Make it easy for the user to select which exercises should be displayed on the graph. I realize this one is a long shot.
If you’re interested in seeing the thing, it’s here.