Any Excel gurus in the house?

Hardware and technical stuff
1

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:

  1. Update the graph when I add a column to the data dump sheet.

  2. Draw lines between data points in the same series even if there is a point missing between them.

  3. 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.

Thanks.