thermometer chart


Posted by Doug F on December 21, 2000 8:09 AM

How can I make a thermometer-type chart to display current progress toward a goal?



Posted by lenze on December 21, 2000 8:29 AM

You could format a column on your worksheet to the width you want and then use conditional formatting to change the backgroud to red as the percentage increases. Simply base the formatting to th econdition to be greater than or equal to the value in a cell where you enter the percentage complete.

Lenze