Macro Help: Light up Image/Shape with changes in data with date

naracena

New Member
Joined
Dec 14, 2016
Messages
1
Bear with me on this one as I'm experimenting with a new interactive dashboard so there's a few ideas being thrown around and I'm still not sure how best to go about it. Effectively I have data changing on a daily basis so have enabled a macro to run through data by day automatically. Showing this in a presentation alongside a visual would however be great. So for instance I want to have an image of the project I'm controlling (a wall construction) alongside the data and have areas of the wall relevant to each days work light up. Still with me?....

So each part of the wall has a tracker assigned to it and 0 means no works done, 1 means work completed. What I've tried is a conditional format so the cell is red if 0 and green if 1. Then copying and pasting the cell, I've the altered that shape to (sort of) assemble a wall component. Now when I run the macro the part lights up when completed (equal to 1). This is however a very crude method of doing this and I'd love some ideas on how to improve on this.

Along with this, the shape is not perfect, so doing something like inserting an image and lighting up parts of the image as data changes could be an option. Or maybe a way of creating a more complex 3d shape on excel than the simple shapes offered would help. Also, the way I use now will mean copying and pasting each cell from the tracker (there's over 100 components) and changing each one to the required shape.

The idea is still an experiment and I'm open to suggestions but any ideas or advice would be much appreciated. Thanks!
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Can you post an example image along with the data please?

And if you've already started a macro, please post that code too.

Thanks!
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,552
Messages
6,114,278
Members
448,560
Latest member
Torchwood72

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top