Thread: In Excel 2007, color for number format axis not working
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Frank[_29_] Frank[_29_] is offline
external usenet poster
  
Posts: 21
Default In Excel 2007, color for number format axis not working
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.
Reply With QuoteReply With Quote