User-defined charts or some other solution?

[Sol Apache]

So far as I understand user-defined charts can only be defined on each
individual computer. Is this correct? If not...

I have an Excel template on a server with its own colour set for charts. I
have set up the different types of charts required. How can these be made
available for everyone in the company through the user-defined (even
default) chart type in Excel?


Thanks for any help




Sol

 

[JE McGimpsey]

So far as I understand user-defined charts can only be defined on each
individual computer. Is this correct? If not...

I have an Excel template on a server with its own colour set for charts. I
have set up the different types of charts required. How can these be made
available for everyone in the company through the user-defined (even
default) chart type in Excel?

Custom chart types are defined on individual machines. The chart type
itself can be stored in a common workbook, and added to multiple users'
machines..

The only way I know of to add to the Custom Chart types is spelled out
in Help ("Create, share, or delete your own chart types"). This can be
done with a macro if desired.

 

[Sol Apache]

My next query:
What goes into the macro? Creating the chart from scratch, then putting it
into the user-defined list? Or what? I do have the charts already created
but I, and the users, would prefer that the template opens to a blank
worksheet.

I also have them all in the user-defined list of this template.

Thanks

Sol

 

[JE McGimpsey]

My next query:
What goes into the macro? Creating the chart from scratch, then putting it
into the user-defined list? Or what? I do have the charts already created
but I, and the users, would prefer that the template opens to a blank
worksheet.

I also have them all in the user-defined list of this template.

Here's one quick and dirty way:

I would create the chart on a one-sheet workbook. Put this in the
ThisWorkbook code module:

Private Sub Workbook_Open()
Application.AddChartAutoFormat _
Chart:=Sheets("Sheet1").ChartObjects(1).Chart, _
Name:="MyNewChart", _
Description:="MyNewChart description"
End Sub

Add additional charts as needed.

Now save the file as an Excel Add-in.

Have the user use Tools/Add-ins to load the add-in. Then close XL.

The user can then leave the add-in loaded or not. If they ever delete
the custom type, they can load the add-in again.