Excel picture in sheet
Excel picture in sheet
(OP)
I am interested in putting an image of a tank in an excel sheet and showing how full it is in cell A1 on the image.
This will show the user how much the tank is full.
Can anyone direct me to how I might do this??
This will show the user how much the tank is full.
Can anyone direct me to how I might do this??





RE: Excel picture in sheet
-handleman, CSWP (The new, easy test)
RE: Excel picture in sheet
What I can suggest that I know works, is that you put your picture of your tank, and then put a Rectangle Shape on top of it to simulate it being filled.
See attachment.
RE: Excel picture in sheet
RE: Excel picture in sheet
RE: Excel picture in sheet
The other way is to use conditional formatting on a vertical range of cells representing the tank. Let say tank is 10 cells high, the value in cell "B2" represents percentage of tank filled.
The bottom cell condition ="$B$2>0" background color = blue
Sectond cell condition =$B$2>=15
......
Top (10) cell condition =$B$2>=95
See attached file.
hope it helps!
RE: Excel picture in sheet
-JTBorton
Well, You can try banging your head against the wall, but you just end up with lost-time injuries and damaged equipment. [M. Passman]