Results 1 to 2 of 2

Bar graph color changing w/values

This is a discussion on Bar graph color changing w/values within the Excel Questions forums, part of the Question Forums category; Greetings, My question is regarding the changing the colors of a bar graph based on value. For example, if the ...

  1. #1
    New Member
    Join Date
    Jul 2016
    Posts
    10

    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,761

    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.

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