XY Chart

Aggregate Y-axis values by X-axis categories

Render Types

XY charts support the following render types, as well as composite charts that combine them.

Line	Bar	Stacked Bar
Area	Stacked Area	100% Stacked Bar
Scatter	Bubble	100% Stacked Area

Specifications

Aggregation

In XY charts, the X-axis is a dimension and the Y-axis is a metric, and Y-axis values are aggregated for each X-axis value. (In XYZ charts, the X-axis and Y-axis are dimensions and the Z-axis is a metric, so Z-axis values are aggregated for each combination of X and Y.)

Item	Role	Notes
X-axis	Dimension	Aggregation unit (aggregated per X)
Y-axis	Metric	Adds a series per metric
Grouping	Dimension	Splits series by value
Bubble size	Metric	Only for bubble rendering

Example Configurations

• Show "Monthly total sales" as a line chart

  • X-axis (Dimension): Month

  • Y-axis (Metric): Total sales

• Show "Total sales by product category" as a bar chart

  • X-axis (Dimension): Product category

  • Y-axis (Metric): Total sales

X-Axis Specifications

In XY charts, the X-axis type is determined by the X-axis data type and the render type composition.

X-axis data type	Render type composition	X-axis classification
Date/Datetime	All	Time axis
Numeric	Scatter/Bubble/Line only	Numeric axis
Numeric	Includes Bar/Area/Stacked	Categorical axis
Other	All	Categorical axis

Categorical Axis

In a categorical axis, even if the specified values are numeric or date/datetime types, they are rendered as discrete values at equal intervals.

Specifying Axis Upper and Lower Limits

When specifying upper or lower limits for a categorical axis, the specified values are treated as indices of the data order (0th, 1st, 2nd...).

Index	X-axis value
0th	1
1st	10
2nd	20
3rd	30
...	...
10th	100

In this case, if you set the axis upper limit to 10, data up to the 10th index will be displayed, which means X-axis values up to 100 will be shown.

Time Axis

In a time axis, the specified date/datetime type data is rendered as a continuous time series.

• Axis labels are dynamically determined based on the specified date/datetime data

• When datetime data with a timezone is specified, it is converted to the timezone specified in the browser for rendering

  • Axis labels are displayed based on the browser time zone. Therefore, if the browser time zone does not match the data time zone, axis labels and data labels may be misaligned

  • Converting to a datetime format without a time zone can also prevent the browser time zone from affecting the dates and times

Numeric Axis

In a numeric axis, the specified numeric type data is rendered as continuous numeric values.

Tips

Reference Line

In XY Charts and XYZ Charts, you can add reference lines to the X-axis and Y-axis. By displaying reference lines or regions such as target values, acceptable ranges, or danger zones, you can visually support data evaluation. Y-axis reference lines are displayed horizontally, and X-axis reference lines are displayed vertically.

• Configuration Method

  • In the chart edit screen "Advanced Settings", select the axis where you want to display the reference line, then click "Reference Line" > "Add". Enter the type and value of the reference line you want to display.

• What You Can Do

  • Line: Display a dashed line at a specific value (e.g., sales target, threshold, specific date marker)

  • Band (Range): Display a semi-transparent band for a specific range (e.g., acceptable range, danger zone, caution period)

  • Color and Label Settings: Choose colors from success (green), warning (yellow), danger (red), and add labels as needed

Trend

In XY Charts and XYZ Charts, you can display trend lines (such as regression lines or moving averages) for series. Trend lines are added as separate series from the original data, helping you visually understand data trends.

• Configuration Method

  • In the chart edit screen "Advanced Settings", click "Series" > "Trend" > "Display" and select the type of trend you want to display.

  • Trend lines are displayed as dashed lines, and for trend types other than moving average, the equation and R² (coefficient of determination) are displayed on the chart. (The coefficient of determination can be hidden.)

Trend Types

Trend Type	Description	Additional Settings
Linear	Displays linear regression (y = mx + c)	None
Polynomial	Displays polynomial regression	Specify degree from 2 to 5
Moving Average	Displays moving average	Specify window size
Exponential	Displays exponential regression (y = ae^(bx))	None
Logarithmic	Displays logarithmic regression (y = a + b ln(x))	None
Power	Displays power regression (y = ax^b)	None

Note: Trend lines will not be displayed if the data count is insufficient or if applying the specified trend type fails.

Statistics

In XY Charts and XYZ Charts, you can display statistical values (mean, median, maximum, minimum) of series as dashed lines.

• Configuration Method

  • In the chart edit screen "Advanced Settings", click "Series" > "Statistics" > "Display" and select the statistical values you want to display.

  • The dashed lines will display the statistics type and its value as labels.

Difference from Trends

Feature	Statistics	Trend
Display Format	Displayed as the same series	Added as a separate series (trend line)
When Zooming Chart	Recalculated only with data in the visible range	Not recalculated (always based on all data)
In Stacked Charts	Appears as a stacked differential	Not stacked