Savings Goal "Thermometer"

[Shhhh]

Hello all,

Is it possible to use excel to create a savings goal thermometer, you the
type where as your savings increase the thermometer increases till you reach
your goal?


Thanks,
Shhhh

 

[Paul B]

Shhhh, may this will help

http://j-walk.com/ss/excel/usertips/tip033.htm

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




--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Roger Govier]

Hi

What a really neat idea!!

 

[Shhhh]

What fantastic methods!! thank you all so much. I never realized just how
versatile Excel was... thanks to all!

Shhhh

 

[Bill Sharpe]

See if this suits you.
http://www.juiceanalytics.com/weblog/?p=236

If your savings are in A1.
B1 =REPT("I",A1)

or

If your savings are in A1 and the goal is in B1.
C1 = REPT("I",(A1/B1*100))

The second formula plots how far you are towards your goal.
It might help to also plot your goal itself with this formula
D1 = REPT("I", 100)

"I", of course, isn't the only character you can use for repeating.

Bill

 

[Dave Peterson]

I like this one (it simulates the cross mark on the 5th entry):

=REPT(REPT(CHAR(134),4)&" ",INT(A1/5))&REPT("|",MOD(A1,5))

With 7 in A1, you'll see something like:
†††† ||

(nice if you're using Arial--not sure how it'll show up in the newsgroup,
though.)