Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving Default Chart Type?
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving Default Chart Type?
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving Default Chart Type?
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/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot apply the default chart type to the selected data | Charts and Charting in Excel | |||
Cant delete user defined default chart type | Charts and Charting in Excel | |||
Setting up a Custom type, User-defined, Default Chart | Charts and Charting in Excel | |||
Pivot Chart - default chart type | Excel Discussion (Misc queries) | |||
Pivot Chart: cannot apply the default chart type... | Charts and Charting in Excel |