Partially fill an image with color, acording with a percentage

[robert_anisoiu]

Hello,

I need help with an Excel file that has two sheets, attached.
In first sheet I have some random numbers (percentages) created with RANDBETWEEN, that changes.
I need to copy the images from the second sheet to the first sheet and to fill each image with color, according to the percentage.
Have you ever dealt with such a thing? Can you help me with some tips?

Thanks to everyone for their help.

[Kaper]

You can make a column type graph and place it behind the pictures. As the pictures have some white fill and some transparent fill regions, the graph will be visible through transparent regions.

Step by step changes and formatting is shown in the attached file (just for one category, you shall do similar graphs for other categories (separate one for each category).

[robert_anisoiu]

You can make a column type graph and place it behind the pictures. As the pictures have some white fill and some transparent fill regions, the graph will be visible through transparent regions.

Step by step changes and formatting is shown in the attached file (just for one category, you shall do similar graphs for other categories (separate one for each category).

Thank you very much, Kaper! You're the best!

[Kaper]

Thanks for kind words and for reputation point.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.