change color of x-axis individual points

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: change color of x-axis individual points

  1. #1
    New Member
    Join Date
    Jul 2013
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default change color of x-axis individual points

     
    a 2
    b 4
    c 6

    I want to plot a line chart with the first col being the x axis and the second col being the y axis. However, i also want the color of each point on the axis to be as in the table. How can i change the default which is black? I know we can change the color of the text on the x axis but we must change all to the same color. I am using excel for mac 2013.

    Thanks.

  2. #2
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,424
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: change color of x-axis individual points

    You mean you want to change the color of each label on the axis?

    This can be done indirectly, by hiding the default labels and adding a hidden series with data labels. These data labels can be individually formatted, which axis labels cannot.

    I wrote a tutorial about it here: Individually Formatted Category Axis Labels.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

  3. #3
    New Member
    Join Date
    Jul 2013
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up Re: change color of x-axis individual points

      
    Quote Originally Posted by Jon Peltier View Post
    You mean you want to change the color of each label on the axis?

    This can be done indirectly, by hiding the default labels and adding a hidden series with data labels. These data labels can be individually formatted, which axis labels cannot.

    I wrote a tutorial about it here: Individually Formatted Category Axis Labels.

    Really smart!

User Tag List

Tags for this Thread

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