Custom Chart Types

  • Thread starter Thread starter Kris Van Baelen
  • Start date Start date
K

Kris Van Baelen

Hi,

Where are user defined custom chart types stored, and can
we access these definitions progammatically in Excel VBA?

Thanks in advance,

Kris
 
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
 
Back
Top