#1   Report Post  
Old July 21st 09, 11:39 AM posted to microsoft.public.excel.charting
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 161
Default Heat Map template


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



Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Heat Map JD McLeod Charts and Charting in Excel 1 June 27th 09 09:21 PM
how do I create a heat map? have x and y data and then a num to s. heat map in excel Charts and Charting in Excel 2 February 2nd 09 09:56 AM
Heat Map Traveler Charts and Charting in Excel 2 June 11th 08 05:50 PM
How can I set up a heat map using excel? MichaelM Charts and Charting in Excel 0 November 28th 07 09:35 PM
heat map ann[_2_] Charts and Charting in Excel 0 March 28th 07 10:17 PM

All times are GMT +1. The time now is 06:22 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017