Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
In Excel 2007, color for number format axis not working
..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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
In Excel 2007, color for number format axis not working
+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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting (Excel 2007) Format Row Color Based on X | Excel Discussion (Misc queries) | |||
Conditional number format in Excel 2007 | Excel Discussion (Misc queries) | |||
Date format on axis in Excel 2007 | Charts and Charting in Excel | |||
Excel 2007 axis format | Excel Discussion (Misc queries) | |||
fill color not working in excel 2007 | Excel Worksheet Functions |