Graph help

[JeffSturgeon2002]

I need to create a graph for my company. The graph takes the monthly goal and for each day it calculates what percentage the group is at. The graph I saw previously was similiar to a thermometer. It would take the goal total and divide it by the daily collections and calulate and move the percentage collected to date up the scale. It was really cool. Anyone have this, or now how to create it?

 

[Andrew Poulsom]

Look here:

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

 

[sweater_vests_rock]

the excelwiki also shows a themometer-type column chart. plus, a handy video!

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

 

[JeffSturgeon2002]

I like these, but I want the graph to move when cash is posted on a day.

Example:

Goal = 1.5 million

Day 1: Collections = $120,000.00
Day 2: Collections = $45,000.00
etc
etc

The graph will slide up the thermometer by percentages based on where the group is in collections. I love the look of the thermometers in this file, just need it to program right.

 

[JeffSturgeon2002]

Found what I needed ....

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