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 function VAR. ... In the chart below, the data points are the blue dots and the orange line is the regression line.