Hi,
Try these examples.
http://www.andypope.info/charts/thermometer.htm
http://spreadsheetpage.com/index.php/tip/creating_a_thermometer_style_chart/
Cheers
Andy

Signature
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
>I would like to create a chart in excel that looks like a thermometer which
> shows progress being made towards a goal. How is this done?