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.)
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.
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...).
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
Multiple Series
When you configure multiple series, a "Indepedent scale" option appears in the series settings. Turning it on gives that series its own Y-axis scale, drawn on the right.
Configure labels and other options for independent Y-axes under "Advanced" > "Independent axes".
When you configure multiple series, a "Split by series" option appears below the "Series" settings. Turning it on gives each series its own Y-axis scale and stacks the charts vertically, one per series.
Enabling "Split by series" disables the frame feature. The "Indepedent scale" option is also hidden, and every series is treated as having an independent axis. Configure per-series Y-axes under "Advanced" > "Independent axes".
Frame Feature
XY charts support the frame feature. See Frame Feature for details.
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
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
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
Last updated
Was this helpful?