This is driving me insane. I have a clustered bar chart and I need to make the bars green for the negative values. But every time I close and reopen the spreadsheet the inverse colour reverts back to white. There are slicers in my spreadsheet but none connected to this particular pivot table & chart and it does not have any filters either.
I'm using Excel 2013, I've had to colour each bar manually for now but I need a permanent solution.
Any suggestions appreciated.
Bookmarks