Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

Create scatter plots with trendlines to visually assess the relationship between variables. You can do this by selecting your data and choosing Insert > Scatter and then adding a trendline.

Each of these new column pairs will be used to plot a series of smaller concentric bull’s-eye circles. When plotted on an Excel Scatter Chart, these data points will form a total of four circles, ...