A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Charts and Charting in Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Heat Map template

Thread Tools Display Modes
Old July 21st 09, 11:39 AM posted to microsoft.public.excel.charting
Risky Dave
external usenet poster
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
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 08: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 08: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 02:23 AM.

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