Pivot chart type changes anytime the table is changed

[AliTabei]

Hi,

I have a pivot chart linked to a pivot table. In the chart, I superimpose two types of charts, a bar chart (on the primary axis) and a line chart (on the secondary axis). Anytime any filter of the columns of the pivot table is changed, the chart type changes to all bar chart and I lose the line chart and the secondary axis. Is there anyway to avoid this?

The bar chart is default chart type that the the pivot chart has to have inevitably.

Thanks,

 

[Dryver14]

If you want the chart to just report on what you have set up then simply create another pivot table..not to be changed and link to the chart to that.