Add R² value, movable equation text box, and custom trendline formatting (color/style)

Suggestions Spreadsheet editor
1

Currently, while we can add a trendline and show its equation, the feature is missing essential options for academic, professional, and statistical reporting.

I would like to suggest the following additions:

  1. Display R² Value: Please add a checkbox to “Display R-squared value on chart” right next to the existing equation option. Calculating it via the RSQ formula and pasting it manually is a tedious workaround.

  2. Movable Label Text Box: The trendline equation box is currently locked in a fixed position. It should be possible to click and drag the text box anywhere inside the chart area to prevent it from overlapping data points, gridlines, or the trendline itself.

  3. Trendline Customization (Color and Style): There is currently no way to change the visual appearance of the trendline. Users should be able to format the line’s color, weight (thickness), and dash type (solid, dashed, dotted) so it can stand out from the main data series.