ExcelBanter - cannot change datasource of pivotchart

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - cannot change datasource of pivotchart (https://www.excelbanter.com/excel-worksheet-functions/254645-cannot-change-datasource-pivotchart.html)

Nikki

cannot change datasource of pivotchart

I have PivotChart that is showing the number of opportunities of each type in
each financial quarter. I want to include a bar to show the total of each
type but the PivotChart wont let me change the data source.

Is there a way around this?

All times are GMT +1. The time now is 08:49 PM.