Settings for Chart

The charting function provides the following options to define a chart. The available options vary according to the chart type.

Setting Item	Description
X axis	Select the column to be displayed on the X-axis. All the available columns for the selected chart are listed in the X-axis list.
Y axis	Select the column to be displayed on the Y-axis from the Y-axis list. The Y-axis list contains the following items: Row count: The number of rows matching the categories on the X-axis. All the numeric type columns.
Color by	Select an available column listed in the Color by list. The column values are represented with different colors in the chart.
Size by	Select an available column listed in the Size by list. The column values are used to calculate the proportion of each item.
Aggregate by	Select the way to aggregate the values matching the same category on the X-axis. sum average max min
Group by	Select an available column listed in the Group by list. If a column is selected, the curve is divided according to the values in this column. For the bar chart, you can determine how to display the curves matching the same category by clicking the radio button, grouped or stacked.