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.

 

[wwbwb]

Look here. http://www.mrexcel.com/wiki/index.php?n=ExcelWiki.CreateAThermometerEffectInYourColumnChart

 

[Von Pookie]

Also:
http://www.andypope.info/charts.htm

http://www.andypope.info/charts/thermometer.htm