Graphic Thermometer, Linked to Data Cell
 

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

Graphic Thermometer, Linked to Data Cell
 

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