I wonder if someone can help me. I have created a pivot chart in excel which displays daily values on a bar graph which are either negative or positive. I have then formatted the data series as follows:
Fill > Invert if negative and chosen green for the positive values and red for the negative ones
The problem is when I save the workbook, close it and go back in, the inverted colour option of the graph has reverted to white.
Hello,
it's a bug. But there's a workaround documented by Jon Peltier in his blog post
Invert if Negative in Excel 2007Summary: don't use a solid fill color. Use a gradient fill color with gradient stops set to appear like solid fill. Example quote below.
Quote:
The Magical GradientI have to admit that I do not understand why this magical gradient works. If I did, I probably wouldn’t call it magical. Mr. Lapajne is either a genius or a madman, or perhaps he swiped the gradient from another genius or madman like I’ve swiped it from him. In any case, the gradient requires four stops, described below:
