Change color for 1 data label in a graph?
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Change color for 1 data label in a graph?

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com