Chart Object VB Code

[MS]

Is there any open source code available that stores every possible setting
for a chart. E.g. if you had a chart as a template and wanted to store the
settings and then wanted to use these settings to apply to another chart.

Also, how many chart objects are there now for Excel for all versions from
2000 and up

Thanks in advance.

 

[MS]

Including for PivotCharts. Thanks

 

[Jon Peltier]

You'd have to write some code to capture all of the settings. You can store
a chart as a user defined type, but even that doesn't store everything. User
defined chart types:

http://peltiertech.com/Excel/ChartsHowTo/CreateCustomTypes.html

Chart objects? That's what you create when you embed a chart into another
sheet. Some days I make hundreds of them.

If you mean chart types, look at step one of the chart wizard next time you
create a chart. The standard tab shows all of the usual types, the Custom
tab shows some combinations that were designed years ago by someone who
didn't make too many charts. But you can design your own custom types
without much problem, and the combinations are limited only by your
imagination:

http://peltiertech.com/Excel/Charts/ComboCharts.html

- Jon