Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Heat Map template
Hi,
I need to devlop a heat map along the following lines. The data elements will be displayed on a 5x5 square grid. Each axis of the grid has a 1-5 scale. The data need to show how their value (X axis against Y axis) has changed (or not, it is possible that they will stay the same) over time - 2 or, if possible 3 months, preferably as an arrow (I can probably do this bit by using one of the Webdings type fonts). There are an unknown number of data elements, but in reality the range is likely to be between 6 and 35. I would like the map to be updated as the result of selecting a button rather than in "real-time". I can code this bit, but don't know where to start on building the chart in VB - can anyone point me to a tempate or model that I can use as the basis of what I need? This will be done in Xl '07 under Vista Enterprise TIA Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Heat Map | Charts and Charting in Excel | |||
how do I create a heat map? have x and y data and then a num to s. | Charts and Charting in Excel | |||
Heat Map | Charts and Charting in Excel | |||
How can I set up a heat map using excel? | Charts and Charting in Excel | |||
heat map | Charts and Charting in Excel |