How to create a Line Chart in Excel To create a line chart in Excel, the procedure is as follows: Select the data across both the columns (from A3 to B12). Go to Insert > Line Chart.

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.

Click the Insert tab located on the toolbar. Choose the desired chart type from the available options, such as bar, pie, or plot (scatter or line) charts.

How to Add a Legend to a Scatter Plot in Excel. The legend on an Excel scatter plot is simply a list of the names for each of the series on the chart. The legend is color coordinated, so you can ...

When plotted on an Excel Scatter Chart, these data points will form a total of four circles, effectively converting a scatter chart into a bull’s-eye chart. Your updated table containing the ...