Click the cell in your spreadsheet in which you would like Excel to display the y-intercept of your line. Type "=INTERCEPT(" without quotes in the formula bar above the spreadsheet.

Five advanced Excel charts discussed: Waffle Charts, Line Charts with Markers, Radar Charts, Variance Charts, and Dumbbell Charts. Waffle Charts visualize capacity or progress using a dynamic ...

To calculate statistical variance in Microsoft Excel, use the built-in Excel ... which attempts to minimize the distance of any individual data point from the line itself. In the chart ...