data series color - conditional formatting Saintsman 12/23/2008 3:10:01 PM 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 [Quoted Text] >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

RE: data series color - conditional formatting Saintsman 12/23/2008 3:30:01 PM Please ignore this - managed to sort out via Peltiers site - which is now one of my favorites! "Saintsman" wrote: [Quoted Text] > 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 >

Re: data series color - conditional formatting "Jon Peltier" <jonxlmvpNO[ at ]SPAMpeltiertech.com> 12/23/2008 3:56:59 PM Thanks! - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Saintsman" <Saintsman[ at ]discussions.microsoft.com> wrote in message news:543128FC-C4B5-47C9-B5D4-E9C050BF36FF[ at ]microsoft.com... [Quoted Text] > 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 >>