6 Replies Latest reply: Dec 15, 2011 11:20 AM by Alan Hendrickx RSS

    Creating a Heatmap / Matrix

    Alan Hendrickx

      Hi,

       

      I am looking to create a risk-type heatmap based on a data column with values like these:

      1A

      3B

      4C

      2A etc

       

      I would like to plot them on a chart that looks like below. The cells should contain a count of the various values (e.g. '1A') and should be plotted by number and letter.

       

      It would also be desirable to colour the cells dynamically based on the count value. For example to highlight a cell in red that was above 15% of the total.

       

      (Impact)

      4

      3

      2

      1

      114
      231
      954
      3210

      A, B, C

      (Possibility)

       

      I am a newbie, so any help that you could provide would be much appreciated!

       

      Thanks

      Al