axis labels different colors

[john lawlor]

Hello,

Is it possible to give different axis labels different colors?

I have tried changing the colors of the text in the cells in the source
spreadsheet range, but it doesn't appear to work.

Any suggestions?

Thanks in advance,

John

 

[Andy Pope]

Hi,

You need to create you own axis labels to have more control over the
appearance of individual labels.
http://www.andypope.info/charts/hiliteaxislabels.htm

Cheers
Andy

 

[john lawlor]

Andy,

My chart is a line chart and the first 10 or so x labels are quarters e.g.
Q1 06 n=24, the next 20 are months e.g. 10/06 n=29. Aligned vertically.

John

 

[Dave Curtis]

Hi John,

Download Rob Boveys chart labeller add-in and it's easy.
Create your line chart as normal, and format the x axis to have no labels.
Add a dummy series all with value 0 (zero).
Colur yourx axis data whichever way you want, and use Robs chart labeller to
add he coloured dta labels to the dummy series, and align vertically.
Format the dummy series to have no line and no markers.

Dave