Kris -
The built-in ones are in XL8GALRY.XLS, located here:
C:\Program Files\Microsoft Office\Office\1033
The ones you define yourself are in XLUSRGAL.XLS, here (on my machine):
C:\Documents and Settings\Jon Peltier\Application Data\Microsoft\Excel
This is for Excel 2000 in Windows XP. You can open these files if you
want, but I don't know what good that would do.
To use one of the built-in custom types, this is the VBA syntax:
ActiveChart.ApplyCustomType ChartType:=xlBuiltIn, TypeName:="TheName"
where TheName is the name that appears in the Chart Type dialog. To use
one of the types you've created, this is the VBA syntax:
ActiveChart.ApplyCustomType ChartType:=xlUserDefined, _
TypeName:="MyChartType"
where MyChartType is the name the user defined when defining the chart type.
- Jon
