shading a picture

I'd like to add shades to a shape which shows a percentage of remaining solution
as the percentage fluctuate the shadow percent does also.

thank you all

Hello,

I've put a text box over the image and allowed for changes in transparency when cell F6 is changed between 0%-100%

Reference:
http://www.ozgrid.com/forum/showthread.php?t=135496

Please Login or Register  to view this content.

Here's a solution that fills up the bottle based on the scrollbar value.

1) I drew a free-form shape the size of the bottle
2) It is filled with a gradient based on the scrollbar value.

Please Login or Register  to view this content.

Originally Posted by Xx7

Here's a solution that fills up the bottle based on the scrollbar value.

1) I drew a free-form shape the size of the bottle
2) It is filled with a gradient based on the scrollbar value.

Please Login or Register  to view this content.

First of all thank you
but the filling only starts after moving the scroll
I wish if this doesn't occur and it would fill automatically as the % is up and empties as it down.
Can this be done?

I changed it so there is no scrollbar. Let me know if that works!

Please Login or Register  to view this content.

Originally Posted by Andy Pope

No code required

Use an image with transparent area as the fill for a column chart.
The second column series provides the fill amount

thank you man!

Really very good idea
But Andy I need you to tell me: how to understand the formula you did in more detail , please refer me to a link or a reference to learn how to modify and put it in my workbook... I am obliged.

excellent idea
thank you again Andy

If you can, how these columns would overlap
I put the 2 series of chart and got 2 columns
the columns overlap is set to 100 but don't overlap
even after adding my transparent image the don't overlap they stay seperated
This is the key problem that is not solved yet!!!!!