data series color - conditional formatting

  • Thread starter Thread starter Saintsman
  • Start date Start date
S

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
Click to expand...

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
 
Please ignore this - managed to sort out via Peltiers site - which is now one
of my favorites!
 
Back
Top