Change color for 1 data label in a graph?

anthy · Feb 18th, 2002, 08:25 AM

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 · Feb 18th, 2002, 12:44 PM

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 · Feb 19th, 2002, 12:11 PM

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!

Feb 18th, 2002, 12:44 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	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. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 18th, 2002, 08:25 AM	#1
anthy New Member Join Date: Feb 2002 Posts: 2	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

Feb 19th, 2002, 12:11 PM	#3
anthy New Member Join Date: Feb 2002 Posts: 2	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!