Chart Type - Thermometer?

[CindyA]

Does anyone out there know of a way to create a chart type that looks like a thermometer? I would like to have the "goal line" as 98.6 degrees and the 'fill' in the thermometer as the spreadsheet is updated. Possibly just one bar in a chart and take away the grid lines, chart border, etc. But I'm looking is some clever soul out there may have a better idea.

Thanks in advance.

 

[NBVC]

Look here:

http://www.mrexcel.com/tip095.shtml

 

[CindyA]

Thermometer Chart

Works great; thank you.

 

[Von Pookie]

You may also want to see the replies that were added to your duplicate post (which is now locked):
http://www.mrexcel.com/board2/viewtopic.php?t=188283

 

[ostrom808]

WOW! I haven't been here since before the message boards. AWESOME! I was looking for a thermometer to track fundraising and found it instantly! And the directions were so clear! THANK YOU!