How To Make A Scatter Plot In Excel

Open the worksheet that contains the data you want to plot on your scatter chart. Highlight all the data you wish to be included as this selects the data which will be plotted on your graph.

Select the Insert tab, and then click the symbol for Insert Scatter (X, Y) or Bubble Chart. This is in the charts group.

This is when you should select Scatter.

By resting your cursor on the various chart symbols, you can see the name and type. You can also see how the chart is best used, in case you’re struggling to decide how to display information. Now you have Scatter selected, you can begin to format your chart.

To open the Design and Format tab, click on the chart. This will pop up new tabs on the top of your screen. Click on the Design tab, and then select the plot style you want.

To add a title it is very simple. To do so, click on the chart title, then right-click on the title to change the font and size.

Click on the Design tab again, and select Add Chart Element, and then Axis Titles. From here, you can add a Primary Horizontal title, and a Primary Vertical title. To do so, click on the title, and type in your text.

These titles can be formatted using the Format tab. Click Format, then Chart Elements, then Format Selection. The Format Title box will appear. Select Size & Properties to alter the alignment, direction, and angle.

Select the Format tab, the Charts Elements box, and then Plot Area.

Next, select Shape Styles on the Format tab, and then select the More button to change effects.

Change the theme using the Page Layout tab. Click the Themes group, and then select Themes. Select Office, and find the theme you want.

Different styles of the scatter plot can be used to display various types of information. Experimenting with the scatter options can help you to see which chart style best displays the information you’re presenting.

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.

Click the Insert tab, and then select X Y Scatter. 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.