Reference Lines and Trendlines in Looker Studio
Available for the following charts:
Reference Line Type:
Metrics: Calculation includes Average, Median, Percentile, Min, Max, and Total.
Constant value: A custom number that is to be displayed on the Left or Right Y-Axis
Editing Charts with Reference Lines
Changing the chart type will delete any reference lines not supported by the new chart type—for example, Line Chart to Scorecard.
Reference Lines Limitation
Reference lines are only available for numeric axes. Reference lines on date axes aren't supported.
Metric-based reference lines calculate based on only the values displayed in the chart. So, for example, if you add a reference line to a bar chart with 10 bars, data from additional bars is not included in the calculation.
It is not possible to use reference lines in 100% stacked charts.
Trendlines in Looker Studio (Formerly known as Data Studio)
Linear: Linear trend lines are straight lines that approximate the data on the chart as closely as possible.
Exponential: You can use an exponential trendline when an exponential of the form eax+b best represents your data.
Polynomial: A polynomial trendline displays data directionality as a curved line. It can help analyze large, highly variable data series.
- Background and Border
- Missing Data
- Conditional Formatting
- Chart Header
- Reference Lines
- Report Settings
- Data Blending
Most Used Features:
- Report Sharing
- Manual Publishing
- Version History
- Embed a Report
- Get a link to your report
- Schedule Email Delivery
- Download as PDF
- Interface Menu & Features
- Most Used Terms
- Keyboard Shortcuts
- Theme and Layout