Goal line
A goal line displays a target value as a horizontal line across your chart. Use it to show targets, thresholds or benchmarks.Goal line configuration.
Goal target value along the y-axis. This is where the horizontal line will be drawn.
Optional marker position on the x-axis. Use this to indicate when the goal applies or when it was set.
Custom label for the goal line. Defaults to “Goal” if not provided.
Goal line with marker
Add a marker to show when a goal was set or when it changes:Trendline
A trendline shows the general direction and pattern in your data using statistical methods. Choose from multiple trendline types depending on your data characteristics.The type of trendline to display. Each type fits a different mathematical model to your data.
Trendline types
Straight line. Best for data that moves up or down at a steady pace.Use when: Your data shows consistent growth or decline
Smooth line that gently follows the overall pattern in the data. Good for bumpy or noisy trends.Use when: You want to see the general direction without being distracted by short-term volatility
Line that bends upward or downward more and more over time. Good for growth rates or compounding changes.Use when: Your data is accelerating or decelerating exponentially
Line that changes quickly at first, then levels off. Good for patterns with diminishing returns.Use when: Your data grows rapidly initially then plateaus
Gently curved line with one clear peak or valley. Good for data that changes direction once.Use when: Your data has a single turning point
Curved line for scaling relationships where one value grows as a power of another (e.g., area vs radius).Use when: You’re showing power law relationships
Flexible curved line that can have several peaks and valleys.Use when: Your data has multiple turning points
Using trendlines
Average line
An average line shows the arithmetic mean of a data series as a horizontal line. Useful for identifying values that are above or below average.Average line configuration.
Column key for the series to calculate the average from. Must match a column key from your data.