You are here:


This function generates heatmap of input data.


AXCEL.VIZ.HEATMAP(data, [title], [deployment])

The AXCEL.VIZ.HEATMAP function syntax has the following arguments:

data Required. data must be a n x m table showing the value of each point. If you would like to show x-axis and y-axis values, you should define y-axis values in the first column and define it as factor with .f and the x-axis are extracted from column names. Here is an example”

y_axis.f (optional) x_value1 x_value2 x_value_n

title Optional. By default, Axcel tries to find the title from your data such as the name of the first column. Otherwise, you can explicitly define the title of your graph.

deployment Optional. It is the deployment in project/name or owner/project/name format. You need to create a project by logging into your console (https://console.axcel.io) -> Project -> Create Project. After that you can use the project name in your deployment. Please note project and visualization names contain small letters and numbers only. If a project is shared with you, you should use the username of the owner in your deployment. Please visit visualization projects and sharing to learn more about this powerful feature.

when you type =AXCEL.VIZ.HEATMAP in an Excel cell, the IntelliSense guides you through required and optional (shown in [] brackets) inputs. Here are examples.


In this example, we use Volcano dataset available in Axcel datasets which is the topographic information for Maunga Whau on a 10m by 10m grid. To do so, in Cell A1 run:


and now run heatmap command to generate the heatmap:

=AXCEL.VIZ.HEATMAP(A1#, “Maunga Whau”)

As you can see, since data was pulled by dataset in A1 as an array, we define input by A1#. Here is the putput:

If you would like to show x-axis and y-axis names, you should define define y-axis in the first column as factor. In a simple example of having y-axis as “y-a”, “y-b” and “y-c” and for x as “x1”, “x2” and “x3” which are located in A1:D4 table, we run:

=AXCEL.VIZ.HEATMAP(A1:D4, “Example”)

As shown, x and y axises have the corresponding names:

See also Visualization Projects and Sharing