caringsharingbristolbilly
Board Regular
- Joined
- Mar 23, 2004
- Messages
- 241
Hi all.
I'm doing a piece of work which shows performance of geographic areas in my region on a number of indicators. I'd like to do a simple map for each of the indicators, whereby each region is shaded by according to its performance (by quintile or quartile, ideally).
There are 14 areas in our region, and the way I thought I could do it was to paste in 14 simple shaded shapes (in, say, blue), placed together so the form the map of the region, and have each one linked to a bit of VBA code to alter the brightness of each one according to a particular value.
Would this be the way you would do it? Or would you suggest a simpler way? And if so, could someone just briefly give me an idea of the VBA command for changing the brightness of a picture object? I've had a look round and an experiment, but I'm a bit of an Excel VBA dunce, and haven't managed to make it work...
Any suggestions would be hugely appreciated, as always.
Many thanks!
I'm doing a piece of work which shows performance of geographic areas in my region on a number of indicators. I'd like to do a simple map for each of the indicators, whereby each region is shaded by according to its performance (by quintile or quartile, ideally).
There are 14 areas in our region, and the way I thought I could do it was to paste in 14 simple shaded shapes (in, say, blue), placed together so the form the map of the region, and have each one linked to a bit of VBA code to alter the brightness of each one according to a particular value.
Would this be the way you would do it? Or would you suggest a simpler way? And if so, could someone just briefly give me an idea of the VBA command for changing the brightness of a picture object? I've had a look round and an experiment, but I'm a bit of an Excel VBA dunce, and haven't managed to make it work...
Any suggestions would be hugely appreciated, as always.

Many thanks!