Pivot Charts Invert Fill Issue

[JeffGrant]

Hi All,

The Issue: Pivot Charts Invert Fill colour deafults to white when workbook is saved.

Does anybody have a solution to this issue? It seems to have been hanging around for years on the internet.

I am running an updated office 365 and this issue is still around.

I have tried a couple of vba solutions, but they dont seem to work in my workbook.

Hoping somebody as solved this one.

Cheers

 

[JeffGrant]

Hi All, I just applied this old hack and this will do as a solution for my needs.

Invert if Negative Formatting in Excel Charts - Peltier Tech

In Excel column and bar charts, positive and negative data can be formatted differently using a feature called Invert if Negative.

peltiertech.com

Hoping others can use this solution.

 

[Alex Blakenburg]

Thanks for sharing. And assuming you applied the hack for the Pivot Chart, here is the direct link to that section.
Invert if Negative Formatting in Excel Charts - Peltier Tech
Direct link doesn't seem to work, search for the heading "Invert if Negative for Pivot Tables"

Note: Mynda Treacy suggests a work around of converting to a standard Chart.
https://www.myonlinetraininghub.com/excel-forum/dashboards-charts/problem-with-invert-if-negative-functionality-in-excel-charts#:~:text=Posts:-,4303,-August 7, 2016

 

[JeffGrant]

Thanks Alex