If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
axis labels different colors
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 |
#2
|
|||
|
|||
axis labels different colors
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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "john lawlor" wrote in message ... 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 |
#3
|
|||
|
|||
axis labels different colors
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 "Andy Pope" wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "john lawlor" wrote in message ... 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 |
#4
|
|||
|
|||
axis labels different colors
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 "john lawlor" wrote: 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 "Andy Pope" wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "john lawlor" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|