I posted code a couple years ago that automated this process. The code and
the custom chart types resided in a workbook which was to be distributed to
those who needed the chart types. You could search Google Groups for my name
and keywords like distribute custom chart types.

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


"Del Cotter" wrote in message
...
On Tue, 5 Sep 2006, in microsoft.public.excel.charting,
graphicslady said:

I am trying to create a template to be distributed throughout the company
to
aid in the creation of standard charts -- colors, patterns, fonts, etc.
Unfortunately, Ihave not been able to get the user-defined chart types to
save with the template. Is it possible to do this? I'm new to Excel, so I
hope I'm just missing something.

Sadly, I believe the best you can do in Excel is send out a template with
the standard charts in it, then instruct all the recipients in how to save
those as user-defined chart types in their own Excel setup. It's a strange
failing on the part of Microsoft, to have failed to provide a way of
distributing user-defined chart types around an organisation.

It might be possible to send out the file in which the user-defined charts
are stored, and instruct people in how to install it in the appropriate
location, but that will end up replacing whatever personalised file they
themselves have created, and many people may be unhappy with that.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.