Fix "Invert if Negative" Color in Charts RRS feed

  • Question

  • In a PivotChart, you can select 2 different data series column fill colors (one for positive and one for negative). However, when I save/close and then reopen the spreadsheet, the positive fill color (as well as all other formatting changes) remains in tact, while solely the negative fill color defaults to white with a black border.

    I am using Office 365 and have enabled "Preserve cell formatting on update" in the PivotChart Options. The only thing that seems to work toto this end is to use Pattern Fill instead of a solid fill (using the negative color as the Foreground and the positive color as the Background), but I simply don't want a pattern fill. Am I missing something? How do I accomplish what I'm trying to do?

    Thank you,


    Thursday, December 12, 2019 5:18 PM