I have a VBA routine that creates a pivot table and then charts it. I have created a user defined chart type and use that to create the chart. This works fine on the first run. The data is fine and the chart is exactly as the users want to see it. As with most pivot tables it has a number of "page" fields such as Site and Department and when the user clicks the dropdown next to them and selects a specific value it redraws the graph based on the new selection. This is where the problem occurs. When it redraws the graph it defaults to a Column graph and not the custom one it started with. I have tried setting the Custom Chart Type as the Excel Default but it makes no difference. Every time they select something from a dropdown or refresh the data it reverts back to a Column Chart. I have a workaround via a button that simply sets the correct chat type for them but I am sure there must be a way round this. Are there any "OnChange" type events I could hook into or does anyone have any other idea on using custom chart types in pivots. I am using 2003 but it also needs to work on 2007 and 2010 unfortunately.