1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Color Chart with Conditions

Discussion in 'Discuss Data Visualizations and Charting' started by Deepak Sharma, Apr 6, 2018.

  1. Deepak Sharma

    Deepak Sharma Member

    Messages:
    164
    Hi Everyone,

    I need to color bar chart with different color for only those people who have not completed 150 hours.

    Please see the attached file.


    Thanks and Regards,
    Deepak Sharma

    Attached Files:

  2. chirayu

    chirayu Well-Known Member

    Messages:
    875
    attached

    Attached Files:

  3. Deepak Sharma

    Deepak Sharma Member

    Messages:
    164
    Hi Chirayu,

    Thank you so much! Can you please tell me the proceedure I need to apply this on my workbook, where there is a huge data around.


    Regards,
    Deepak Sharma
  4. chirayu

    chirayu Well-Known Member

    Messages:
    875
    Basically there are 2 series of data in the chart. if you right click on chart & click on select data you will see that series 1 is Hours and series 2 is the formula for below 150. Then once data added, right click on the bars for series 2 and click on format data series, then change the series overlap to 100%
    Deepak Sharma likes this.
  5. Deepak Sharma

    Deepak Sharma Member

    Messages:
    164
    Thanks Chirayu....Thank you so much!

Share This Page