Hi gang,
Unfortunately we're switching to Office 2007 at work and in testing I ran into this strange "bug?" that Microsoft doesn't seem to care about because it's behaving the same way in Office 2010 as well.
Here's the situation. If you open the attached file, I have the same custom number format in the chart's data labels and in the cells. Why does it work in the cells but not when used on data labels in a chart?
According to this site it should be [color25] that I'm going after (a custom red).
click here
I'm so confused.