changing color of data series based on value

[lezawang]

Hi
I have simple table like the one below. I wanted to insert a bar chart. I am wondering if I can change the color of each individual chart to different color (not manually), I know if i click on any bar and then click again to select that bar only (lets say Mary's bar) then I can change the color but I am wondering if I somehow link he chart color to the person name in columnA? thanks

[TABLE="width: 500"]
<tbody>[TR]
[TD]salesperson[/TD]
[TD]sales[/TD]
[/TR]
[TR]
[TD]mary[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]john[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]alex[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]