User defined chart-type error

[Neil]

Hi,

I currently have a pivot chart which refreshes when the report is
opened. To this i have set it up with a user defined template and
called the template 'Neil'.

When opening up the report it works fine for me. But when other people
go to open the same report they get a debug error box pop up. The
error message is:

Run-time error '1004':
Method 'ApplyCustomType' of object'_Chart' Failed

When i go to debug it shows me this line of code as being the problem:

ActiveChart.ApplyCustomType ChartType:=xlUserDefined, TypeName:="Neil"

If i change the line to say: TypeName:="Default" the report seems to
work fine for everyone. But i want to be able to apply various changes
to the template rather than use the default layout.

Any help would be greatly appreciated.

Thanks
Neil

 

[Gord Dibben]

User-defined Charts are not saved with the workbook.

They are stored in a file named XLUSRGAL.xls on your computer.

If others do not have access to that file..............error message.


Gord Dibben MS Excel MVP