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

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

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

Best Regards

NooK


---
Message posted from http://www.ExcelForum.com/

.