Change default chart in a macro to prevent run time error when creating a pivot charts

Hello,

I am creating a macro to make a pivot chart. The issue is that when someone sets their default charts/graphs to be a scatter plot the macro returns a runtime error because the pivot table data cannot generate a scatter plot. How do you specify that the pivot chart needs to be an "xlColumnStacked" to ensure the runtime error does not occur?

My initial thinking was that you could specify a change to the default chart prior to creating the pivot chart in the macro but I have been unable to find a solution to do this.

Please note that i am making this macro for persons not familiar with macros and they may not know how to change the default chart setting. Ultimately they will not know that the issue is their default chart setting. My goal is to just prevent this scenerio in the first place and have the macro work on anyone's laptop with no issues regardless of their settings.

Any help would be appreciated.

Please Login or Register  to view this content.

set the chart type on the addchart method.

Please Login or Register  to view this content.