Retrieving Default Chart Type?

[NooK]

I looked everywhere but couldn't find it, is there a way I can retriev
the default chart type in Excel through VBA?

I need to change it so I would like to set it back to what it wa
before after I've done it what I needed.

Best Regards

Noo

 

[NooK]

Isn't there anyway to do it?

Best Regards

Noo

 

[Peter T]

Hi NooK,

Create and select a temporary chart:

CType = ActiveChart.ChartType

If you are trying to change and restore the original
Default Chart be aware that the "ChartType" is only one of
a whole bunch of properties you might have changed.

Have you considered creating your own Custom User defined
Chart and applying that instead of the Default - would
avoid messing with the Default. Custom Types / User-
defined / Add.

Alternatively, store the Default chart as a User defined
Chart (as above, named say "Default_orig"), do your stuff,
and reset Default_orig as the Default chart.

Should be possible to record a macro for each of the
above, and adapt to your needs.

Regards,
Peter