Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting the font of X axis values
Hello,
In Excel 2007, the X axis labels I have chosen are as follows: -1, 3, 4, -3 etc. i.e. the X axis reads the above numbers. However I am trying to format the numbers as follows so that the negative numbers will show red. 0.0;[Red]-0.0 The X axis for some reason does not seem to take the above formatting. Any ideas why? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting the font of X axis values
On Sun, 26 Jul 2009 23:02:05 -0700, Tigerxxx
wrote: Hello, In Excel 2007, the X axis labels I have chosen are as follows: -1, 3, 4, -3 etc. i.e. the X axis reads the above numbers. However I am trying to format the numbers as follows so that the negative numbers will show red. 0.0;[Red]-0.0 The X axis for some reason does not seem to take the above formatting. Any ideas why? If your chart is of the type "X Y (Scatter)" this formatting works. But if you chart is of some other type, like Bar, Line, Column, I guess the X-axis labels are interpreted as text and not as numbers. What type of chart do you have? Lars-Åke |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting the font of X axis values
It is a regular column chart. Wish tehre was some way to format the X axis
numbers...! "Lars-Ã…ke Aspelin" wrote: On Sun, 26 Jul 2009 23:02:05 -0700, Tigerxxx wrote: Hello, In Excel 2007, the X axis labels I have chosen are as follows: -1, 3, 4, -3 etc. i.e. the X axis reads the above numbers. However I am trying to format the numbers as follows so that the negative numbers will show red. 0.0;[Red]-0.0 The X axis for some reason does not seem to take the above formatting. Any ideas why? If your chart is of the type "X Y (Scatter)" this formatting works. But if you chart is of some other type, like Bar, Line, Column, I guess the X-axis labels are interpreted as text and not as numbers. What type of chart do you have? Lars-Ã…ke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data labels along below x axis when y axis has negative values | Charts and Charting in Excel | |||
How do I reference x-axis or y-axis scale values to a worksheet ce | Excel Discussion (Misc queries) | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
How do I change X-Axis values in a chart with 2 Y-Axis? | Charts and Charting in Excel | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel |