Exporting custom chart types

[rdionne]

I've created a custom chart type. I want other users to be able to use this custom type also. How do I place this custom chart type on other people's machines? I'm using VBA to generate the charts.

Thanks

 

[Mark W.]

Why don't you apply the chart attributes using your VBA?

 

[rdionne]

Because they interact quite a bit with each other, and the order that you assign the attributes is also important. I tried the VBA route, but it turned out to be a frustrating experience. Too bad there isn't a utility that takes a chart and displays all of the attributes. I guess I can add two hidden worksheets containing the two custom chart types I use to my excel app., and then define the custom chart types from those:

Application.AddChartAutoFormat Chart:=ActiveChart, Name:="Test", _
Description:="Test Chart"

 

[Mark W.]

On 2002-05-08 15:08, rdionne wrote:
Because they interact quite a bit with each other, and the order that you assign the attributes is also important. I tried the VBA route, but it turned out to be a frustrating experience. Too bad there isn't a utility that takes a chart and displays all of the attributes. I guess I can add two hidden worksheets containing the two custom chart types I use to my excel app., and then define the custom chart types from those:

Application.AddChartAutoFormat Chart:=ActiveChart, Name:="Test", _
Description:="Test Chart"

Have you considered distributing a Book.xlt file containing the Custom Chart type and have 'em put it in their XLStart folder?

 

[rdionne]

Hmmm that isn't a bad idea. How does one find out where their XLStart folder is. Is an .XLT file a template?

 

[Mark W.]

> How does one find out where their XLStart
> folder is.

Use the Windows Find Files or Folders... command

> Is an .XLT file a template?

Yes. See the Excel Help topic for....

"Customize the defaults for a workbook or worksheet by using a template"


BUT... the more I think about it the more I doubt that these defaults are stored in the worksheet. This begs the question, "Then where?" Which currently I don't have the answer to!!!
This message was edited by Mark W. on 2002-05-08 16:19

 

[Mark W.]

[bump]

 

[Mark W.]

YEESSS!!! See the Excel Help Index topic for...

"Custom chart types"

...notice (in the fine print)...

"If you have added your own custom chart types, they are in the file Xlusrgal.xls."