Extract Excel Chart Trendline Coefficients To The Grid - 2338

У вашего броузера проблема в совместимости с HTML5

Michel asks how to get the chart trendline coefficients from the chart into the grid.

Table of Contents
(0:00) Question from Michel
(0:27) Adding a trendline to a chart with the formula
(1:14) How to tell if your Excel has Dynamic Arrays
(1:30) Entering LINEST function with additional statistics
(2:54) Entering LINEST with Ctrl+Shift+Enter (Before Dynamic Arrays)