Recovering chart properties in vba

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

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
 
Back
Top