Themometer Charts in Excel

Reader Abhay Jain sent me a cool workbook with a themometer chart embedded in the worksheet. At first glance, I couldn't figure out how he did it. Abhay uses a clever technique to turn a single cell's value into a column chart and then formats the chart to make it appear as a themometer. Read the complete details at http://www.mrexcel.com/tip095.shtml.