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!
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!
