Exporting custom chart types

rdionne · May 8th, 2002, 03:27 PM

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. · May 8th, 2002, 03:48 PM

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

rdionne · May 8th, 2002, 04:08 PM

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. · May 8th, 2002, 04:11 PM

Quote:

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 · May 8th, 2002, 04:21 PM

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. · May 8th, 2002, 05:12 PM

> 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. · May 8th, 2002, 05:19 PM

[bump]

Mark W. · May 8th, 2002, 05:31 PM

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."

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 03:27 PM	#1
rdionne New Member Join Date: Feb 2002 Location: Texas Instruments Posts: 47	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

May 8th, 2002, 03:48 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Why don't you apply the chart attributes using your VBA?

May 8th, 2002, 04:08 PM	#3
rdionne New Member Join Date: Feb 2002 Location: Texas Instruments Posts: 47	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"

May 8th, 2002, 04:21 PM	#5
rdionne New Member Join Date: Feb 2002 Location: Texas Instruments Posts: 47	Hmmm that isn't a bad idea. How does one find out where their XLStart folder is. Is an .XLT file a template?

May 8th, 2002, 05:12 PM	#6
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	> 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 ]

May 8th, 2002, 05:19 PM	#7
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	[bump]

May 8th, 2002, 05:31 PM	#8
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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."