Overview
Trendlines help explain the overall direction of data by fitting calculated values on top of a series. They reduce noise, expose long-term movement, and make forecasting easier. You can add multiple trendlines to any supported series and configure their style with a few properties.
Types

Linear
A linear trendline is a straight line used with simple linear data sets. It usually shows something increasing or decreasing at a steady rate.

Exponential
An exponential trendline is a curved line used when data values rise or fall at increasingly higher rates. If your data contains zero or negative values, you cannot create an exponential trendline.

Logarithmic
A logarithmic trendline is a curved line that is most useful when the rate of change in the data increases or decreases rapidly and then levels out. It can use either negative or positive values.

Polynomial
A polynomial trendline is a curved line used when data fluctuates. The polynomial order can be determined by the number of fluctuations in the data or by how many bends appear in the curve.

Power
A power trendline is a curved line best used with data sets comparing measurements that increase at a specific rate.

Moving average
A moving average trendline is a smoothed line that averages values across a fixed window, making the underlying direction easier to read when the series has short-term spikes.
Supporting features
Markers
Show or hide trendline markers, choose a built-in shape, and adjust the marker size so key points are easy to spot.
Forecast
Extend a trendline forward or backward by setting a forecast value. This helps visualize projected values beyond the current data range.
Legend
The legend displays each trendline with its icon and label, making it easy to identify which line represents which calculation in the chart.
Trackball
Trendline values appear in the trackball tooltip, so users can see the exact projected value at any point they touch on the chart.
Our Customers Love Us