BAR CHART

You are here:

AXCEL.VIZ.BARCHART function

This function generates bar chart plot of input data.

Syntax

AXCEL.VIZ.BARCHART(data, [stacked], [subplot_rows], [orientation], [title], [deployment])


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

data Required. data must be a minimum of two columns. If subplot_rows is not 0, then the 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 well.

Group(optional)itemsvalue1value2(optional)value …m(optional)
aitem13.51.4
aitems131.4
bitem23.21.3
bitem23.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”. 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

stacked Optional. Default is FALSE which shows multiple data grouped in separate bars. You should set it TRUE, if you would like to show them, stacked on each bar. This item is set automatically to FALSE when subplot_rows is greater than 0.

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

orientation Optional. Default is vertical. If you can set it to [h]orizontal, if you would like to have the charts presented horizontally.

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

Example:

We have sore transaction of two stores A and B presented in this table and is located at A1:E9:

Store.f Item.f Inventory SalesReturns
AComputers $ 120,000.00  $        44,000  $   12,000
ATablets $   55,000.00  $        16,000  $     5,500
AMobile Phones $ 160,000.00  $        66,000  $   16,000
AMonitors $   44,000.00  $        10,000  $     4,400
BComputers $ 120,000.00  $        44,000  $   12,000
BTablets $   55,000.00  $        16,000  $     5,500
BMobile Phones $ 160,000.00  $        66,000  $   16,000
BMonitors $   44,000.00  $        10,000  $     4,400

Let’s start by visualizing Inventory, Sales and Returns aggregated at Item level and call it “Stores Transactions US Dollar”. Please note that Item name is changed by .f to identify it as a factor:

=AXCEL.VIZ.BARCHART(B1:E9,,,,”Stores Transactions (US$)”)

And here is the output:

As you can see, Axcel does the aggregation part for you and show the result at item level. If you would like to show it horizontally:

=AXCEL.VIZ.BARCHART(B1:E9,,,”H”,”Stores Transactions (US$)”)

Which results in:

If you want to show same data vertically but stacked:

=AXCEL.VIZ.BARCHART(B1:E9,TRUE,,,”Stores Transactions (US$)”)

and here is the result:

Lastly, let’s present this chart for each store separately in 2 rows. To do so, we simply run:

=AXCEL.VIZ.BARCHART(A1:E9,,2,,”Stores Transactions (US$)”)

which shows the bar chart as follows:

See also Visualization Projects and Sharing