In cell H29 is a function-created (average) percentage number, say 94%.

In cell J2 is a manully inputted upper threshold percent number, say 98%
In cell J4 is a manully inputted lower threshold percent number, say 92%

Color protocol:
=J2 is Green
between J2 and J4 is Yellow
<=J4 is Red

In this example, the required color is Yellow (94% is between 98% and 92%).

I have to create a graphic of a thermometer showing the color, the percentage (cell H29), and have the thermometer depict a line representing the 94%.

Does anyone know how to create such a graphic, or is there a template somewhere? The graphic is to be located in an Excel worksheet and must respond automatically to changes in the cells.

Thanks,
Phil

Hi
see:
http://andypope.info/charts/thermometer.htm

--
Regards
Frank Kabel
Frankfurt, Germany


Phil Hageman wrote:
In cell H29 is a function-created (average) percentage number, say
94%.

In cell J2 is a manully inputted upper threshold percent number, say
98%
In cell J4 is a manully inputted lower threshold percent number, say
92%

Color protocol:
=J2 is Green
between J2 and J4 is Yellow
<=J4 is Red

In this example, the required color is Yellow (94% is between 98% and
92%).

I have to create a graphic of a thermometer showing the color, the
percentage (cell H29), and have the thermometer depict a line
representing the 94%.

Does anyone know how to create such a graphic, or is there a template
somewhere? The graphic is to be located in an Excel worksheet and
must respond automatically to changes in the cells.

Thanks,
Phil