PivotChart - Changing the data source

[jeanne.pascual]

Hi,

I cannot figure out how to change the data source of our PivotChart.

I tried to use Excel Help but the problem is, the Change Data Source button supposedly available in Analyze tab isn't there.  I tried manually adding the button but nothing happens.  I tried the select data on the Design tab but the Chart data range is greyed and cannot be changed.

Can anyone help me?

[#2]

Hi @jeanne.pascual, 

I have the same problem that you had. I was wondering if you succeeded with your issue and if you could help me.

Thank you and have a great day,

Leo F