Speaking of "retrograde changes" (thanks, David), this is something that's
lost its helpfulness in Excel 2007. Excel 2003 and previous versions would
remember all changes you made during your visit to the dialog, then undo
them all with Ctrl+Z or apply them to another object with F4. Excel 2007
only remembers the absolute last thing you changed in the dialog, or
sometimes it seems to remember nothing at all.
I'm working on a replacement charting UI that will correct for this
shortcoming, but it's not going to be available any time soon.
- Jon