xlusrgal.xls in excel 2007

[Guest]

Can anyone tell me how Excel 2007 handles the user-defined chart format? In
previous versions, user can create their own chart formats and copy/register
these foramts in Excel through xlusrgal.xls file. I am having problem in
converting my old macro to Excel 2007 because this file is no longer
supported by new Excel. Thanks.

Eric

 

[Jim Rech]

Interesting question although I've never used xlusrgal.xls. I don't see
anything on this in the Knowledge base. I think an MVP should asked the
internal MS resources they have access to.<g>

--
Jim
| Can anyone tell me how Excel 2007 handles the user-defined chart format?
In
| previous versions, user can create their own chart formats and
copy/register
| these foramts in Excel through xlusrgal.xls file. I am having problem in
| converting my old macro to Excel 2007 because this file is no longer
| supported by new Excel. Thanks.
|
| Eric

 

[Jon Peltier]

I've been trying to figure out the rest of Excel 2007's charting
infrastructure, and I haven't even gotten to custom chart types. A short
excursion into this has been very interesting.

On the Chart Tools/Design tab, click on Save As Template, and the active
chart is saved as a chart template (for example, Chart1.crtx) in
C:\Documents and Settings\{user account}\Application
Data\Microsoft\Templates\Charts. The crtx file seems to contain just the
chart-related parts of an xlsx Excel 2007 workbook file.

Instead of juggling a bunch of chart sheets within a single gallery
workbook, now you can juggle a bunch of chart template files within this
directory (or presumably any hard disk location).

- Jon