Ping Jon Peltier: Custom colors above & below horizontal lines

[LeAnne]

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

 

[LeAnne]

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/Charts/HorizLineOnColChart.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

 

[Jon Peltier]

Thanks for sharing your solution with everyone. What you did is pretty
much what I was going to suggest.

- Jon