Color of a particular label on the Axis
 

Is it possible to have a color different from the other ones for a
particular label on the x-axis?


--
rvExcelNewTip
------------------------------------------------------------------------
rvExcelNewTip's Profile: http://www.excelforum.com/member.php...o&userid=15668
View this thread: http://www.excelforum.com/showthread...hreadid=501007

Color of a particular label on the Axis
 

Hi,

Have a look at this page. The last chart image contains a single
formatted axis label.
http://www.andypope.info/charts/staggeredlabels.htm

Cheers
Andy

rvExcelNewTip wrote:
Is it possible to have a color different from the other ones for a
particular label on the x-axis?



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Color of a particular label on the Axis
 

This page shows how to change label colors through custom number formats:

http://peltiertech.com/Excel/NumberFormats.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"rvExcelNewTip"
wrote in message
news:rvExcelNewTip.21kdja_1137140401.3643@excelfor um-nospam.com...

Is it possible to have a color different from the other ones for a
particular label on the x-axis?


--
rvExcelNewTip
------------------------------------------------------------------------
rvExcelNewTip's Profile:
http://www.excelforum.com/member.php...o&userid=15668
View this thread: http://www.excelforum.com/showthread...hreadid=501007

Color of a particular label on the 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: )


--
rvExcelNewTip
------------------------------------------------------------------------
rvExcelNewTip's Profile: http://www.excelforum.com/member.php...o&userid=15668
View this thread: http://www.excelforum.com/showthread...hreadid=501007

Color of a particular label on the Axis
 

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

rvExcelNewTip wrote:
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: )



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Color of a particular label on the Axis
 

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?)


--
rvExcelNewTip
------------------------------------------------------------------------
rvExcelNewTip's Profile: http://www.excelforum.com/member.php...o&userid=15668
View this thread: http://www.excelforum.com/showthread...hreadid=501007