I would like to make x-y charts in Excel 2000 with dynamic source data. That
is, the user can select what data set he wants to display.

To do this, I need better control of how the axis limits are defined. This
can be achieved in one of two ways:

1. Use numbers from cells to define xmin, xmax, ymin, ymax.
2. Define in some way how auto-scaling decides what the min and max values
are (I often find that the data gets "scrunched" into a small portion of the
plot area).

Method 1 is preferred, but 2 may also work. I would prefer to do this
without writing a VBA macro, if possible.

Does anyone know if this can be done?