| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| color coding different data series | Charts and Charting in Excel | |||
| conditional formatting-different data to one color | Excel Discussion (Misc queries) | |||
| Conditional color formatting entries have wild color. | Excel Discussion (Misc queries) | |||
| Conditional formatting of a data series in an Excel Chart? | Excel Discussion (Misc queries) | |||
| How do I color specific data series based on location on data she | Charts and Charting in Excel | |||
Linear Mode
