data series color - conditional formatting

[Saintsman]

Frequency chart
I have some frequency data
Chart labels Range bin value
0 - 250 4 250
250 - 500 7 500
500 - 600 6 600
600 - 700 7 700
700 - 800 10 800
800 - 900 1 900
900 - 1000 4 1000
1000 - 1250 4 1250
1250 - 1500 1 1500
1500 - 2000 0 2000
2000 - 2500 1 2500
2500 - 3000 0 3000

3000 3

I want to plot a simple histogram chart, but assign colors to each bin value
How do I do this? I don't want to keep manually changing colors - we are
still amending ranges & I want to automated the color options if possible
I used Peltier conditional formatting, but that only works on the frequency
count rather than the bin values
Any ideas

 

[Saintsman]

Please ignore this - managed to sort out via Peltiers site - which is now one
of my favorites!

 

[Jon Peltier]

Thanks!

- Jon