Register
Log In
Unanswered
Home
New Member
August 7, 2016
Offline
I do encounter a problem when using the invert if negative functionality in Excel 2013 Charts. I have a pivot chart where I have inverted the colors and set them to be red if values are negative.
This works fine. But when I re-open my workbook (saved when closed) the inverted colors (red) are gone and the color is set back to default white. Any help to get this issue solved is very much appreciated.
See Answer
July 16, 2010
Offline
Hi Erwin,
Pivot Charts have a bug where formatting is lost upon refresh. I suspect this is the culprit.
The workaround is to create a regular chart from the PivotTable as opposed to a Pivot Chart.
Mynda
Answers Post
New Member
October 28, 2014
Offline
I had the same problem. I did not want to move away from Pivot Chart, the Gradient Fill method discussed at https://peltiertech.com/invert-if-negative-excel-2007/ Â has actually worked for me.
cheers
Most Users Ever Online: 57
Currently Online: clark shao
15 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Md. Rahman
Lilian Vo
Jane Kumwenda
David Miller
Efe Onwochei
LynAnn Williams
Brandy Kriger
purna chandar
E K
velissa barr
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
