Color of a particular label on the Axis

  • Thread starter Thread starter rvExcelNewTip
  • Start date Start date
R

rvExcelNewTip

Is it possible to have a color different from the other ones for
particular label on the x-axis
 
I tried Jon's method because it looked the most straightforward, but I
couldn't achieve the desired result.

Here's a description of the problem at hand: The Range that contains
the X-Values has the numbers 0,01 to 0,99 formatted as % i.e. they show
up in the spreadsheet at 1% to 99%. Y-values are in an adjacent column,
corresponding to some mathematical function. The function is plotted on
a smooth line XY-chart and the Chart is contained in a separate chart
sheet.

The Value on the X- axis that I like to highlight is 0,30 i.e. 30%.
The X-axis is scaled fron 0,00 (0%) to 1,00 (100%) with a primary
interval of 0,1(10%).

I doubleclicked the X-axis labels and formatted them as follows:

[Red][<>0,3]0,00%;[Blue]0,00%
[Red][<0,3]0,00%;[Red][>0,3]0,00%;[Blue]0,00%
[Blue][=0,3]0,00%;[Red]0,00%

All three format turned ALL x-labels Red! no Blue in sight! What went
wrong?

(There used to be a time when a hand-drawn function was quicker, albeit
less professional looking :rolleyes: )
 
Hi,

This worked for me when the axis font colour is set to Red.

[Blue][<0.3]0.0%;[Blue][>0.31]0.0%;0.0%

Cheers
Andy
I tried Jon's method because it looked the most straightforward, but I
couldn't achieve the desired result.

Here's a description of the problem at hand: The Range that contains
the X-Values has the numbers 0,01 to 0,99 formatted as % i.e. they show
up in the spreadsheet at 1% to 99%. Y-values are in an adjacent column,
corresponding to some mathematical function. The function is plotted on
a smooth line XY-chart and the Chart is contained in a separate chart
sheet.

The Value on the X- axis that I like to highlight is 0,30 i.e. 30%.
The X-axis is scaled fron 0,00 (0%) to 1,00 (100%) with a primary
interval of 0,1(10%).

I doubleclicked the X-axis labels and formatted them as follows:

[Red][<>0,3]0,00%;[Blue]0,00%
[Red][<0,3]0,00%;[Red][>0,3]0,00%;[Blue]0,00%
[Blue][=0,3]0,00%;[Red]0,00%

All three format turned ALL x-labels Red! no Blue in sight! What went
wrong?

(There used to be a time when a hand-drawn function was quicker, albeit
less professional looking :rolleyes: )
Click to expand...
 
Andy, Yes it worked! The trick seems to be the slightly different
interval boundary (0,30 and 0,31) for both conditions. Strange Excel
logic (or not?)
 
Back
Top