Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / September 2006

Tip: Looking for answers? Try searching our database.

Save user-defined chart types in a shared Excel template?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
graphicslady - 05 Sep 2006 13:29 GMT
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.
Del Cotter - 06 Sep 2006 00:03 GMT
>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.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
   which goes to a spam folder-- please send your email to del3 instead.

graphicslady - 06 Sep 2006 00:53 GMT
Thanks. That's what I was afraid of.

> >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.
[quoted text clipped - 13 lines]
> personalised file they themselves have created, and many people may be
> unhappy with that.
Jon Peltier - 06 Sep 2006 13:20 GMT
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
_______

>>I am trying to create a template to be distributed throughout the company
>>to
[quoted text clipped - 13 lines]
> location, but that will end up replacing whatever personalised file they
> themselves have created, and many people may be unhappy with that.
Angela's Diner - 06 Sep 2006 15:38 GMT
I KNOW HOW TO DO THIS!!
Finally I can help somebody out after getting help from this forum as a
lurker for years.

OK, the file that gets created/populated with the user-defined charts is
called XLUSRGAL.xls .

You will have to copy this file to the correct location in Documents and
Settings on each individual system in order for the users to have access to
your chart templates.  Here's my path  C:\Documents and
Settings\"username"\Application Data\Microsoft\Excel  

Obviously "username" is what you replace with each user's name.  I've shared
and modified user-defined charts and successfully shared them between 3
systems this way.

props to Chip who originally discovered this one,
A

> 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.
Jon Peltier - 07 Sep 2006 05:20 GMT
No offense, but you don't know how to do this. Your process will overwrite
each user's custom chart gallery. Not a graceful deployment mechanism. If
someone did this to me, I would be very upset.

Here is a link to my post from a couple years back, in which I described how
to distribute user defined chart types with a workbook and a small macro. No
users' charts are harmed by this process.

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

>I KNOW HOW TO DO THIS!!
> Finally I can help somebody out after getting help from this forum as a
[quoted text clipped - 23 lines]
>> save with the template. Is it possible to do this? I'm new to Excel, so I
>> hope I'm just missing something.
Debra Dalgleish - 07 Sep 2006 13:50 GMT
Maybe this is the link that Jon meant to include:


http://groups.google.com/group/microsoft.public.excel.charting/msg/210f8a219326de1a

> No offense, but you don't know how to do this. Your process will overwrite
> each user's custom chart gallery. Not a graceful deployment mechanism. If
[quoted text clipped - 38 lines]
>>>save with the template. Is it possible to do this? I'm new to Excel, so I
>>>hope I'm just missing something.

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Jon Peltier - 07 Sep 2006 14:07 GMT
I'd like to introduce my technical editor, Debra Dalgleish.

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

> Maybe this is the link that Jon meant to include:
>
[quoted text clipped - 44 lines]
>>>>I
>>>>hope I'm just missing something.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.