Tank Inventory Graph

[bkish]

I am looking to build a simple spreadsheet that takes an Excel Shape that resembles a tank and overlays it with a color to show how full it is. I was thinking the amount colored in would be based on the amount of capacity/amount in tank. I know there are ways to do this but cannot think of how to word my search in order to find it.

Please let me know if this is not clear to you.

 

[Andrew Poulsom]

Like these?

http://spreadsheetpage.com/index.php/tip/creating_a_thermometer_style_chart/

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

 

[bkish]

These helped me apply my concept. I ended up taking my picture and pasting it in the graph, instead of the thermometer.

Thanks.