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

Since there's no clear way of knowing what initial type of chart the user
may be starting from, you need to loop through all chart properties. There
are a lot of these properties, so your looping will be rather complex.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Bob" wrote in message
ups.com...
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