How do you create user-defined charts (as they were called in 2003) in Excel
2007?

Select the chart, go to Chart Tools Design tab Type group Save As
Template button.

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


"Laura Battarbee" wrote in
message ...
How do you create user-defined charts (as they were called in 2003) in
Excel
2007?

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?

"Jon Peltier" wrote:

Select the chart, go to Chart Tools Design tab Type group Save As
Template button.

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


"Laura Battarbee" wrote in
message ...
How do you create user-defined charts (as they were called in 2003) in
Excel
2007?

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Laura Battarbee" wrote in
message ...
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?

"Jon Peltier" wrote:

Select the chart, go to Chart Tools Design tab Type group Save As
Template button.

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


"Laura Battarbee" wrote in
message ...
How do you create user-defined charts (as they were called in 2003) in
Excel
2007?

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\C ommon\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" wrote:

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?

"Jon Peltier" wrote:

Select the chart, go to Chart Tools Design tab Type group Save As
Template button.

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


"Laura Battarbee" wrote in
message ...
How do you create user-defined charts (as they were called in 2003) in
Excel
2007?

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
_______


"Laura Battarbee" wrote in
message ...
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\C ommon\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" wrote:

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?

"Jon Peltier" wrote:

Select the chart, go to Chart Tools Design tab Type group Save As
Template button.

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


"Laura Battarbee" wrote in
message ...
How do you create user-defined charts (as they were called in 2003)
in
Excel
2007?