First, open your worksheet and arrange the data for the scatter plot.

For this, you need to enter data in two different columns. The data on the left side will be present on the x-axis of the scatter plot, and the data on the right side will be on the y-axis.

After you’ve arrange the data, use your mouse to select the two columns. Make sure to select every cell that needs to be in the scatter plot.

Now, go to the Insert tab, and click on the scatter icon.

When you do, a menu will appear on the screen from where you can select different designs for the scatter plot.

After creating a scatter plot in Excel, you can use the icons on its right side to customize it.

If you click on the + icon, you can choose from different chart elements, such as gridlines, error bars, trendlines, and more.

Similarly, clicking on the brush icon will allow you to change the color and design of the scatter plot.

Open the worksheet that contains the data you want to plot on a scatter chart.

Select all the data you wish to be included in the scatter plot.

Then, click the Insert tab, and select X Y Scatter. Next, under Scatter, pick your chosen chart.

With the scatter plot created, you can begin to edit and design your chart. Select the Chart Design tab to access your options.

• From Chart Design, you can modify the titles, labels, legend, etc. using Add Chart Element.
• Use Quick Layout to select from predefined chart elements.
• In the Style Gallery, you can change the layout and style using previews.
• Adjust the data view using Switch Row/Column or Select Data.
• Use the Design tab to change the shape fill, outline, and effects.