PIE CHART

You are here:

AXCEL.VIZ.PIECHART function

This function generates pie chart plot of input data.

Syntax

AXCEL.VIZ.PIECHART(data, [subplot_rows], [hole], [title], [deployment])


The AXCEL.VIZ.PIECHART 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)itemsvalues
aitem13.5
aitem13
bitem23.2
bitem23.1

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:

subplot_rows Optional. It is used when you have grouped data. Default is 0, which assumes there is no grouping. If it is greater than 0, data should have minimum 3 columns. In this case, first column is considered as the grouping index.

hole Optional. Default is 0. If you would like to change your pie chart to a donut, you should define the hole size here. This value is set to 0 when you have multiple pie charts.

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

Example:

We have sore sales of two stores A and B presented in this table which is located at A1:C9:

Store.f Item.fSales
AComputers $        44,000
ATablets $        16,000
AMobile Phones $        66,000
AMonitors $        10,000
BComputers $        44,000
BTablets $        16,000
BMobile Phones $        66,000
BMonitors $        10,000

Let’s start by visualizing Sales aggregated at Item level and call it “Store Sales”. Please note that Item name is changed by adding .f to identify it as a factor:

=AXCEL.VIZ.PIECHART(B1:C9,,,”Store Sales”)

And here is the output:

If you want to show it like a donut, you should define the hole size:

=AXCEL.VIZ.PIECHART(B1:C9,, 0.6,”Store Sales”)

Which generates this donut chart:

In next step, let’s generate the pie chart for each store of A and B and show them in one row:

=AXCEL.VIZ.PIECHART(A1:C9, 1,, “Store Sales”)

Which results in:

See also Visualization Projects and Sharing