software

Is it possible to have a color different from the other ones for a
particular label on the x-axis?--
rvExcelNewTip
------------------------------------------------------------------------
rvExcelNewTip's Profile: www.excelforum.com/member.php...oamp;userid=15668
View this thread: www.excelforum.com/showthread...hreadid=501007Hi,

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

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

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

peltiertech.com/Excel/NumberFormats.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;rvExcelNewTipquot; gt;
wrote in message
news:rvExcelNewTip.21kdja_1137140401.3643@excelfor um-nospam.com...
gt;
gt; Is it possible to have a color different from the other ones for a
gt; particular label on the x-axis?
gt;
gt;
gt; --
gt; rvExcelNewTip
gt; ------------------------------------------------------------------------
gt; rvExcelNewTip's Profile:
gt; www.excelforum.com/member.php...oamp;userid=15668
gt; View this thread: www.excelforum.com/showthread...hreadid=501007
gt;

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][lt;gt;0,3]0,00%;[Blue]0,00%
[Red][lt;0,3]0,00%;[Red][gt;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 )--
rvExcelNewTip
------------------------------------------------------------------------
rvExcelNewTip's Profile: www.excelforum.com/member.php...oamp;userid=15668
View this thread: www.excelforum.com/showthread...hreadid=501007Hi,

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

[Blue][lt;0.3]0.0%;[Blue][gt;0.31]0.0%;0.0%

Cheers
Andy

rvExcelNewTip wrote:
gt; I tried Jon's method because it looked the most straightforward, but I
gt; couldn't achieve the desired result.
gt;
gt; Here's a description of the problem at hand: The Range that contains
gt; the X-Values has the numbers 0,01 to 0,99 formatted as % i.e. they show
gt; up in the spreadsheet at 1% to 99%. Y-values are in an adjacent column,
gt; corresponding to some mathematical function. The function is plotted on
gt; a smooth line XY-chart and the Chart is contained in a separate chart
gt; sheet.
gt;
gt; The Value on the X- axis that I like to highlight is 0,30 i.e. 30%.
gt; The X-axis is scaled fron 0,00 (0%) to 1,00 (100%) with a primary
gt; interval of 0,1(10%).
gt;
gt; I doubleclicked the X-axis labels and formatted them as follows:
gt;
gt; [Red][lt;gt;0,3]0,00%;[Blue]0,00%
gt; [Red][lt;0,3]0,00%;[Red][gt;0,3]0,00%;[Blue]0,00%
gt; [Blue][=0,3]0,00%;[Red]0,00%
gt;
gt; All three format turned ALL x-labels Red! no Blue in sight! What went
gt; wrong?
gt;
gt; (There used to be a time when a hand-drawn function was quicker, albeit
gt; less professional looking )
gt;
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info


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: www.excelforum.com/member.php...oamp;userid=15668
View this thread: www.excelforum.com/showthread...hreadid=501007