G
Guest
How do you create user-defined charts (as they were called in 2003) in Excel
2007?
2007?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jon Peltier
Select the chart, go to Chart Tools > Design tab > Type group > Save As
Template button.
- Jon
Template button.
- Jon
G
Guest
Excel tries to save it to a 'charts' folder underneath the template path. My
users don't have write access to the template path, is there anywhere else we
can store it, so that Excel can still pick them up?
users don't have write access to the template path, is there anywhere else we
can store it, so that Excel can still pick them up?
J
Jon Peltier
I couldn't find an alternative templates directory. But clarify this for me.
My sample chart template was stored in Documents and Settings\{user
name}\Application Data\Microsoft\Templates. Other folders under App Data
contain user settings for a variety of programs. I guess I could understand
closing off Program Files\Microsoft Office\Templates, but why is the
Documents and Settings directory closed off to the users?
- Jon
My sample chart template was stored in Documents and Settings\{user
name}\Application Data\Microsoft\Templates. Other folders under App Data
contain user settings for a variety of programs. I guess I could understand
closing off Program Files\Microsoft Office\Templates, but why is the
Documents and Settings directory closed off to the users?
- Jon
G
Guest
They seem to need to be saved to whereever you template path is set to in
'UserTemplates' in
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\General]
In our case, we set this path to point to a server the users don't have
write access to.
Storing the chart templates in any other template path i.e.
'SharedTemplates' etc means that Excel can't pick them up again if you want
teh apply it to a chart
'UserTemplates' in
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\General]
In our case, we set this path to point to a server the users don't have
write access to.
Storing the chart templates in any other template path i.e.
'SharedTemplates' etc means that Excel can't pick them up again if you want
teh apply it to a chart
J
Jon Peltier
There doesn't seem to be an ability to use an alternate template path in
addition to the one defined by the installation. I thought Office 2003
allowed this, but I can't really remember, and it's too late to check. (Too
late for me because it's after midnight, too late for you since you already
have Excel 2007.)
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
addition to the one defined by the installation. I thought Office 2003
allowed this, but I can't really remember, and it's too late to check. (Too
late for me because it's after midnight, too late for you since you already
have Excel 2007.)
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
Laura Battarbee said:They seem to need to be saved to whereever you template path is set to in
'UserTemplates' in
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\General]
In our case, we set this path to point to a server the users don't have
write access to.
Storing the chart templates in any other template path i.e.
'SharedTemplates' etc means that Excel can't pick them up again if you
want
teh apply it to a chart
Laura Battarbee said:Excel tries to save it to a 'charts' folder underneath the template path.
My
users don't have write access to the template path, is there anywhere
else we
can store it, so that Excel can still pick them up?