Bar graph color changing w/values

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

Thread: Bar graph color changing w/values

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

    Default Bar graph color changing w/values

     
    Greetings,
    My question is regarding the changing the colors of a bar graph based on value.
    For example, if the value in the cell is 550, I want the color to stay green up to 500 and then change to red for anything over 500 up to the 550.

    Thank you for your assistance.

    Paul

  2. #2
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    18,955
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Bar graph color changing w/values

      
    Hi Paul

    Jon Peltier explains here how:

    Conditional Formatting of Excel Charts - Peltier Tech Blog
    Kind regards
    PGC

    To understand recursion, you must understand recursion.

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