data series color - conditional formatting
 

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

data series color - conditional formatting
 

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

"Saintsman" wrote:

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

data series color - conditional formatting
 

Thanks!

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Saintsman" wrote in message
...
Please ignore this - managed to sort out via Peltiers site - which is now
one
of my favorites!

"Saintsman" wrote:

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