Is there a way to edit data source in pivot charts

[Fanta0575]

Am trying to edit data source in a pivot chart to append a calculated column (not part of the pivot chart), when I go to select sata source everything is greyed out and there is no apparent way to be able to add another field, is there a workaround to this, I get limited functionality when I try to add a calculated field

 

[bobsan42]

I don't know what is your office version, so it maybe a bit differents on your machine.
Select the Chart, then additional contextual ribbon tabs appear. Go to PivotChart Analyze > [Data] Change Data Source > Change Data Source ...

 

[Fanta0575]

I don't know what is your office version, so it maybe a bit differents on your machine.
Select the Chart, then additional contextual ribbon tabs appear. Go to PivotChart Analyze > [Data] Change Data Source > Change Data Source ...

Have the chart analysze tab appear on the desktop version but this does not help either, my 365 subscription does not have the analyse tab its the family version and it does not give me option to add it

 

[RoryA]

A pivot chart always, and only, uses the pivot table for its data. You cannot change that.

 

[Fanta0575]

A pivot chart always, and only, uses the pivot table for its data. You cannot change that.

After diplicating a pivot column Is there a way to uniquely use formula to manipulate data on a pivot column so that I could overlap the data series to be able to appear condionally format them

 

[RoryA]

After diplicating a pivot column Is there a way to uniquely use formula to manipulate data on a pivot column so that I could overlap the data series to be able to appear condionally format them

If it’s not part of the pivot table, it will not be part of the pivot chart.

 

[Fanta0575]

If it’s not part of the pivot table, it will not be part of the pivot chart.

Yes bit by duplicating a column ie putting it twice into the values section on the pivot builder is there a way of manually changing the data with a formula ie like a calculated column

 

[Fanta0575]

If it’s not part of the pivot table, it will not be part of the pivot chart.

Managed a workaround I inserted a calculated column and put a formula in. That way I was able to overlap the columns where I had red colour for minus figures and green colour for positive figures