SCATTER

You are here:

AXCEL.VIZ.SCATTER function

This function generates scatter plot of input data.

Syntax

AXCEL.VIZ.SCATTER(data, [grouped], [subplot_rows], [title], [deployment])


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

data Required. data must be a minimum of two columns. If grouped is TRUE, data should have a minimum of 3 columns. In this case, the first column is used for grouping data. If additional columns of data after the two data columns are provided, the first column is used as a reference for coloring data and the next column is used for the size of dots. In summary the structure of input data is as follows:

Group(optional)x_datay_datadots_color(optional)dots_size(optional)
a5.13.51.40.2
a4.931.40.2
b4.73.21.30.2
b4.63.11.50.2

For non-numeric entries such as Group in above example, you should add “.f” at the end of column name to identify it as factor. Also, for dates you should add “.d”. If you add “.n” at the end of a column, you can drop it out from your analysis. For instance, in above mentioned dataset, since Group is not numerical, we should present this column as follows:

Group.f
a
a
b

grouped Optional. Default is FALSE. You should set it TRUE, if your data is grouped and you would like to have separate plots for each. In that case, the first column is used for grouping index.

subplot_rows Optional. It is used when you have grouped data. Default is 1, which shows all graphs in a row. You can define the number of rows, if you would like to have different orders.

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

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.

Example:

In mtcars dataset provided belwo – you can pull this data by running =AXCEL.DATASETS(“mtcars”) – we would like to have a scatter plot for hp vs. drat.

We need to run:

=AXCEL.VIZ.SCATTER(D1:E33)

and here is output:

NOw, if you add wt and qsec by running:

=AXCEL.VIZ.SCATTER(D1:G33)

and here is the output:

As shown, each point is presented with a different color and size which represents the additional information in columns F and G in the dataset.

Now, we would like to go back to our disp vs. hp plot but grouping them by cyl (Column B). Also, we would like to show them in 3 separate rows. As a result, we should run:

=AXCEL.VIZ.SCATTER(B1:D33, TRUE, 3)

and here is the output:

As you can see, data is grouped in 4,6, and 8 cylinder and shown in 3 rows.

See also Visualization Projects and Sharing