Can the bars of a bar graph be different colors?

[meeple]

If I make a bar or column graph, the bars / columns are always the same color. I see how right clicking the graph I can change the color of the bars, but it always changes all the colors (ie for all the bars in the single graph). I want to color code each bar to match some text notes I am making. Is there a way to make one bar red and another green on the same graph for example?

Thanks.

 

[Andrew Poulsom]

Maybe this will help you:

http://peltiertech.com/Excel/Charts/format.html#CondChart

 

[klb]

Click on any bar to select all bars and click again on the bar you want to change and then right click to format that bar.

 

[meeple]

Thanks so much. That link has so much great stuff and klb's method wrks perfectly. Thanks again!