Bar Chart Color Question
 

Excel 2007. I have constructed a simple vertical bar chart with one variable. I would like the bar colors to be determined by a dummy variable that accompanies each plotted value. The dummy variable has only 4 values so each of the bars will be one of 4 colors. This seems like an easy task but I'm stumped. What is the easiest way to do this? Thx

Penthor