Thermometer chart?

[cyberwarrant]

New here. Also trying learn excel. Not even sure if there is such a name for a chart. I have seen it when they do fund raisers with the goal and the amount recieved so far. Need to build a chart that shows total services due, and on the same bar show the number of services completed, and as more are completed the bar moves up closer to the total due.

Thank you for the assistance.

 

[njimack]

Welcome to the board. Take a look at http://www.andypope.info/charts/thermometer.htm

 

[cyberwarrant]

WOW! Is there a way to insert a column chart and make it do that?

 

[njimack]

The 1st 3 charts in the link I gave you are based on a column chart.

 

[Akashwani]

Hi, Welcome to MrExcel.

Take a look here....

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

Good luck.

Ak

 

[cyberwarrant]

Thanks to both of you. I appreciate the info. I am trying to build this and make a chart with 7 columns work. And on top of that setting this up with the directions is making sense of all of this is a bit of a struggle. I'm not the sharpest knife in the drawer