LINE

You are here:

AXCEL.VIZ.LINE function

This function generates line plot of input data.

Syntax

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


The AXCEL.VIZ.LINE 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, they will be presented as additional lines in your graph. However, when grouped is TRUE, these columns are ignored by this function.

Group(optional)x_datay_data1y_data2(optional)y_date … (optional)
a5.13.51.4
a4.931.4
b4.73.21.3
b4.63.11.5

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”, and for time or data-time format you should add “.t” or “.dt”, respectively. 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.

slider Optional. Default is FALSE. If set TRUE, a range selector slider for x-axis will be added to the graph.

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.LINE in an Excel cell, the IntelliSense guides you through required and optional (shown in [] brackets) inputs. Here are examples.

Example:

We have monthly stock price of Silicon Valley Bank (SVB), Microsoft (MSFT) and Apple (AAPL) since November 2015 presented in columns A to D. Also, please note that we added “.d” to the name of Date column (Date.d) to identify it as a column with “Date” format. We would like to plot all three stock. So, we need to run:

=AXCEL.VIZ.LINE(A1:D61)

And here is the output:

let’s add a title such as “Stock Price” and a slider to the graph:

=AXCEL.VIZ.LINE(A1:D61,,,TRUE,”Stock Price”)

Here is the output:

Now, let’s look at SVB stock and group it by year. First we create a column extracting year of dates and then run (please note that grouped is set to TRUE):

=AXCEL.VIZ.LINE(A1:C61, TRUE)

and here is output:

And lastly, let’s group data to before 1/1/2018 (A) and after (B) and plot them in two rows:

=AXCEL.VIZ.LINE(A1:C61, TRUE, 2)

and here is the output:

See also Visualization Projects and Sharing