Hi,
Is there any way that I can recover all the formatting information on a
chart in VBA? I would like to create an excel chart in which a user
could make normal changes to the chart (such as chart type, line
colors, axis marks, etc) and then have those changes summarized so that
the chart could be reproduced as exactly as possible from vba without
having to have the actual workbook. I am thinking that either looping
through all the chart properties of a completed chart (which might be
too many properties) or some type of track changing from an initial
chart might be best. Any ideas?

Thanks,
Bob