how to add single horizontal bar in excel sheet that contain 3 colors

[manali]

hi,
I don't know how to use bar chart in excel sheet. please help me. I have written some test case which contain PASS,FAIL and BLOCKED status. Now i want to display a single horizontal bar with 3 different color which shows the status of test case. It should display PASS test cases with green color,FAIL with red color and BLOCKED with black color. and PASS/FAIL/BLOCKED status should change as status of test cases changed.
Thank You!

 

[Derek Brown]

Hello and welcome to The Board.
Jon's site has a lot of useful examples of charts and this may help you:
Jon's Excel and Chart Pages - Peltier Tech Blog