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.

Including for PivotCharts. Thanks

"MS" wrote in message
...
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.

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/ChartsH...stomTypes.html

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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"MS" wrote in message
...
Including for PivotCharts. Thanks

"MS" wrote in message
...
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.