Change color for 1 data label in a graph?

[anthy]

Hi.

I'm new to this forum, so if this is a question that has been asked before, please forgive me. I've done a search, and I can't find anything, so...

I have a graph with percentage labels (50%, 41%, etc.) on each data point. I'd like to somehow highlight one of the number labels (i.e., 41%) by making it a different color, or bold, or larger, or italics, or putting an asterisk by it, etc.

Asterisks don't work, since Excel interprets any non-numerical entry as zero. Colors/size/bold/italics don't seem to work - they show up fine in the spreadsheet, but don't show on the graph itself. I can change the font for all of the number labels for a series, but that's not what I'm looking for - I just want to change the color for one specific label.

Is there any way to do this? Am I missing something obvious?

Thanks in advance,

Anthy

 

[Juan Pablo González]

You were close. Select the series by clicking on it, then click AGAIN on the data point you want, that should select it ALONE, then you can make it bold, italic, etc.

 

[anthy]

Thank you, that worked! (Though I do feel like a dolt now, because the solution was right in front of my nose...)

A related question - I have a data sheet view of the graph right underneath the graph itself. Do you know of any way to change the font color for just one of the percentages in the data sheet? When I change the font of percentage on the graph, it doesn't change there, as well...

Thanks again for your help!