Results 1 to 2 of 2

Bar Graph Colours

This is a discussion on Bar Graph Colours within the Excel Questions forums, part of the Question Forums category; Good evening All, Is it possible for the colour of a bar on a bar graph to be determined by ...

  1. #1
    Board Regular
    Join Date
    Aug 2006
    Location
    Zimbabwe
    Posts
    234

    Default Bar Graph Colours

    Good evening All,

    Is it possible for the colour of a bar on a bar graph to be determined by the size of the bar e.g. values between 0 & 2 are green, values between 3 and 5 are orange etc? If so, how do i do it?

    Thank you
    Herbiec

  2. #2
    Board Regular cyrilbrd's Avatar
    Join Date
    Feb 2012
    Location
    seated
    Posts
    3,808

    Default Re: Bar Graph Colours

    Quote Originally Posted by Herbiec09 View Post
    Good evening All,

    Is it possible for the colour of a bar on a bar graph to be determined by the size of the bar e.g. values between 0 & 2 are green, values between 3 and 5 are orange etc? If so, how do i do it?

    Thank you
    Herbiec
    Hi have you tried Peltier's solution? link here. specifically this method here: link.
    Φ(𝑘)𝛼Α𝑡
    O365P+ Post sample data using one of these: MrExcel HTML Maker Excel jeanie Forum Tools add-in or Borders-Copy-Paste

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