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

- In Graph variable, enter a numeric or text column that determines the color gradient of the rectangles in the heatmap.
- 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.
- 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.
- 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 |

... | ... | ... | ... |