swedish_user
New Member
- Joined
- May 30, 2012
- Messages
- 2
I was happy to see that the “invert if negative” with a possibility to select the negative value color was back in the charts of Excel 2010.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
However, there seems to be a problem when using “invert if negative” with defined colors in a pivot chart. <o></o>
I have a pivot chart where I have inverted the colors and set them to be red if values are negative.<o></o>
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.<o></o>
Is this a bug in pivot charts in Excel 2010?<o></o>
Is it possible to write a macro that add inverted (red) colors if the values are negative? I have tried to record one, but it doesn’t work… and I am not that skilled in VBA,<o></o>
Thanx for any help<o></o>
However, there seems to be a problem when using “invert if negative” with defined colors in a pivot chart. <o></o>
I have a pivot chart where I have inverted the colors and set them to be red if values are negative.<o></o>
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.<o></o>
Is this a bug in pivot charts in Excel 2010?<o></o>
Is it possible to write a macro that add inverted (red) colors if the values are negative? I have tried to record one, but it doesn’t work… and I am not that skilled in VBA,<o></o>
Thanx for any help<o></o>