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,
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,