If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Ping Jon Peltier: Custom colors above & below horizontal lines
Hello again,
I was wondering if you had any suggestions on how to color-code "zones" within a chart. Using some the techniques described on your (EXTREMELY helpful!!) website, I have created a box-and-whisker plot, and added horizontal lines indicating certain target values (upper and lower). I would like to conditionally color-code the plot areas delineated by these upper and lower horizontal lines...i.e. below the 5th percentile line=red, above the 25th percentile line=green, between the 5th and 25th percentiles=yellow. Any thoughts, ideas, recommendations etc. would be greatly appreciated. Thanks in advance, LeAnne Astin |
#2
|
|||
|
|||
Never Mind, I Solved it! (WAS: Ping Jon Peltier)
Holee catz! I actually figured out one possible solution to this
problem. all by my wittle self. There may be other, more elegant options. But this is what I did: 1. Create your upper and lower horizontal lines as described at http://www.peltiertech.com/Excel/Cha...nColChart.html 2. Select the *lower* horizontal line, right-click, select Chart Type, and change to Area (1st sub-type). 3. Select the *upper* horizontal line, right-click, select Chart Type, and change to Area (1st sub-type). 4. Select the *lower* horizontal line, Format Selected Data Series, select the Patterns tab, then choose your color (Yellow in this case) under Area 5. Select the *upper* horizontal line, Format Selected Data Series, select the Patterns tab, then choose your color (Green in this case) under Area 6. Finally, select the bottom (X) axis, then use the Paint Bucket (Fill Color) button on the Draw toolbar to fill in the lower "zone" with the color of your choice (red in this case). Hoping that others may find this useful, LeAnne Astin |
Thread Tools | |
Display Modes | |
|
|