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
    12
    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
    19,569
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    2 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.

Some videos you may like

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
  •