OK... I tried.. but it doesn't work... What I did ... I open VBE and click on
the Chart, on my right, I have Chart_Activate(), so I put the script you
provided underneath it and saved... but it doesn't work.

Did I do something wrong?

"Rav99" wrote:

> I created a Pivot chart from Pivot table, however, as the user changes the
> options (from pivot fields), then the chart type changes back to default one
> (I want the line-column 2 axes one). I figured I could go to VBA properties
> to default the chart type by choosing the chart code, however under that
> list, there is no chart code for that combination chart (line chart + column
> chart with 2 axes). How can I do this?
>
> Can someone help... as I am not good at VBA? Thanks!