You can make an Excel scatter plot assigning one of the variables in each record to the x-coordinate and one to the y-coordinate on a standard graph axis.

While Excel includes a legend automatically when you create the scatter plot, there are a number of ways to delete it; if your legend is missing you can get it back through the "Layout" tab.

Learn how to create five professional and impressive Excel charts and visuals. To make your numbers stand out in your next presentation.

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, ...

Read: How to create a Line Chart and Scatter Plot Graph in Excel. How to calculate CPI in Excel? To calculate CPI in Excel, you need to use a formula like this: =[(Cumulative price of basket of ...