Change color of a particular category label in Excel 2007

P

prahz

Hi,

I have a bar chart with average SAT scores of various private
schools. On the vertical axis are school names. I would like to
change the format of one particular school to Bold & Red while leaving
the text color of all of the other schools Unbolded and Black. I would
also like to change the bar color for this particular school to Red
while leaving the bars for the other schools Black.

I have had trouble figuring this out. Can anybody help?

Paul
 
A

Amit Velingkar [MSFT]

Hi Paul,

Thanks for your question. The general rule with chart selection is that
clicking once selects the entire series and clicking again selects a
particular point (or in this case the bar) on the chart.

Try selecting an individual bar and try formatting it with the options on
the Chart Tools -> Formatting tab (or use right click menu).

Let me know if this works.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select text of a particular shading color (VBA macro) 5
batch change font color 0
To change the color of particular word 0
Excel 2010 Conditional Formatting 2
Cells Change Color in 2007 0
Change text box background color depending on value in Label Reports 0
Change font color automatically 7
change color of weekend days 2

Top