View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Angela's Diner Angela's Diner is offline
external usenet poster
 
Posts: 1
Default Save user-defined chart types in a shared Excel template?

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

"graphicslady" wrote:

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.