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

salesperson	sales
mary	100
john	200
alex	10

<tbody>
</tbody>