Excel Chart - Themometer

[amylex]

Hello!

This is a math-type question. I am using this guide:

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

To create a thermometer to show how close we are to completion. Basically I have a total of 42 sessions with 3 complete and I need the thermometer to show what % we are complete in a 100% graph. In the guide there is a phrase:

"The thermometer chart is a chart based on a single data point. In a lone cell, put a formula that points towards your percentage completion towards a goal. If the original number is a percentage, multiply by 100 to get an integer value between 0 and 100.".

I don't know how to do this. I am trying to find out if there is a formula to just convert this for me as I am really lost at this point.


Thanks in advance for any help I may receive.

 

[PawPawGary]

Assume the following on your worksheet:
Goal of 42 in cell A1
Completion of 3 in cell A2
Percent of Goal (A2/A1) in cell A3
In this case the value in cell A3 would be 0.071429 or 7.14%
For the chart to work correctly this needs to be changed to an interger (i.e. not a fraction) so you need to multiple the value in A3 by 100 so 0.071429 becomes 7.1429 and the chart will use 7.

Hope this helps,
Gary