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.