how do I create a heat map? have x and y data and then a num to s.
 

I have x and y data and for each number I then have a 3rd number. I would
like to create a chart where for each x and y, you see a colored range for
the 3rd values - like a heat map. any idea how to do this in excel?

Thx.

how do I create a heat map? have x and y data and then a num to s.
 

Hi,

Try the chart type of Surface, it can be done here with some work.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"heat map in excel" wrote:

I have x and y data and for each number I then have a 3rd number. I would
like to create a chart where for each x and y, you see a colored range for
the 3rd values - like a heat map. any idea how to do this in excel?

Thx.

how do I create a heat map? have x and y data and then a num to s.
 

Try on the base of my recent reply:

http://www.microsoft.com/communities...charting&fltr=
--
Petr Bezucha


"heat map in excel" wrote:

I have x and y data and for each number I then have a 3rd number. I would
like to create a chart where for each x and y, you see a colored range for
the 3rd values - like a heat map. any idea how to do this in excel?

Thx.