Inverted color for negative values in pivot-charts is set to white when reopening the file
Inverted color for negative values in pivot-charts is set to white when reopening the file.
This seems to be an error in Excel according to many post in various forums. Would be nice to see this fixed in the future.
Excel team, please fix this issue, i face this problem very badly
I echo the comments below. Either fix it or remove the feature.
Microsoft Excel Team, Why would you not fix this? Why is this not a priority? How about some empathy for your customers who use Excel. I bet Satya Nadella would agree that a feature like this should have been fixed a long time ago. I'd like to think the Excel Team is reasonable.
On August 05, 2016 15:46 (see below), Scott Ruble (PM MSFT) (Admin, Office.com) commented that this issue would be resolved. It has been almost 3-years. What is the holdup, Excel Team?
Adrian Arroyo commented
Please from all the excel community, FIX this bug!
Please fix this, Microsoft Excel team. This bug was identified long ago and should have been fixed by now. I’ll bet every person on the Excel team agrees with me. So why has the fix been neglected?
Mike Baker commented
Well, it's been a LONG time! This is clearly a bug - please address in next release.
I am surprised that more people have not voted for this feature. However, I pretty sure the reason for this is because the average Excel user doesn't know how to use the inverted color feature on a graph. Thus it would great if the Excel team would provide a fix on this issue, which has been known for many years.
Among others, additional links below:
Thanks for the additional details. We have captured this issue in a bug and will consider it in our future planning.
here is a link to a forum where several people have this problem.
and here a description of the workaround in order to get the result despite the excel bug:
I hope this information helps to understand the problem.
Thanks a lot in advance!