Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Save user-defined chart types in a shared Excel template?
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Save user-defined chart types in a shared Excel template?
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Save user-defined chart types in a shared Excel template?
Thanks. That's what I was afraid of.
"Del Cotter" wrote: 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. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Save user-defined chart types in a shared Excel template?
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. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Save user-defined chart types in a shared Excel template?
Maybe this is the link that Jon meant to include:
http://groups.google.com/group/micro...0f8a219326de1a Jon Peltier wrote: 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 _______ "Angela's Diner" <Angela's wrote in message ... 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. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Save user-defined chart types in a shared Excel template?
I'd like to introduce my technical editor, Debra Dalgleish.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Debra Dalgleish" wrote in message ... Maybe this is the link that Jon meant to include: http://groups.google.com/group/micro...0f8a219326de1a Jon Peltier wrote: 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 _______ "Angela's Diner" <Angela's wrote in message ... 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. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you save and share "user-defined chart type's" in Excel? | Charts and Charting in Excel | |||
July - UK Excel User Conference | Excel Discussion (Misc queries) | |||
How do i create a user defined chart in Powerpoint or excel? | Charts and Charting in Excel | |||
I have had difficulty in creating user defined functions in Excel | Excel Worksheet Functions | |||
Excel Rainfall Chart template | Charts and Charting in Excel |