Complete the following steps to specify the data for your graph.

  1. In Graph variable, enter a numeric or text column that determines the color gradient of the rectangles in the heatmap.
  2. From Function, select the function of the Graph variable. For example, if you select Maximum, the color gradient of the rectangles in the heatmap will be based on the maximum value of the Graph variable in each rectangle. If you enter a text column in Graph variable, you can only select Percent equal to a value, Number of nonmissing values, or Number of missing values.
    Some options require you to enter additional values. For more information, go to Select the function.
  3. In Row variables, enter up to five columns that define the rows. You must enter at least one column in either Row variables or Column variables. The columns can be text or numeric and must be the same length as the column you enter in Graph variable.
  4. In Column variables, enter up to five columns that define the columns. You must enter at least one column in either Row variables or Column variables. The columns can be text or numeric and must be the same length as the column you enter in Graph variable.

In this worksheet, Infections is the graph variable. The two row variables are Region and Age. The column variable is Month. The heatmap shows the sum of Infections for each cross section of the row and column variables.

C1 C2 C3 C4
Month Region Age Infections
July West 0-49 25
July South 0-49 906
July West 50+ 282
... ... ... ...
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy