In Excel 2007, color for number format axis not working

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

..Axes(xlCategory).TickLabels.NumberFormat = "+0.00%;[Red]-0.00%;
[Blue]0.00%"

It works in Excel 2003 but in 2007, the colors don't make it (the rest
does).

If I tried manually, it does not work either

I've googled around but not to avail.

Any ideas?
 
+0.00%;[Red]-0.00%;[Blue]0.00%

copy above.The above worked for me.There was a space before [Blue].It
may be due to pasting or actually present
 
Hi Javed.

No, I have no space.

What's puzzling is that +0.00%;[Red]-0.00%;[Blue]0.00% works on the
vertical axis but not the
horizontal: .Axes(xlValue).TickLabels.NumberFormat = "+0.00%;
[Red]-0.00%;[Blue]0.00%"
I should mention that I use Excel 2010, not 2007.

In the formating, only the colors fail. The rest of the formating
works.
 
Back
Top