Mastering Data Visualization: How To Craft Scatter Plots with Microsoft Excel

Quick Links

• Create a Scatter Plot
• Format Your Scatter Plot

Key Takeaways

First, highlight the data you want to use for your scatter plot. Select the “Insert” tab on teh ribbon and click the Insert Scatter option in the Charts group. Choose the type of scatter plot you want to insert.

A scatter plot, sometimes referred to as a scatter chart or XY chart, compares the relationship between two different data sets. This makes it easier to visualize two sets of values in your Excel spreadsheet . Here’s how it works.

Create a Scatter Plot

To create a scatter plot, open your Excel spreadsheet that contains the two data sets, and then highlight the data you want to add to the scatter plot.

Once highlighted, go to the “Insert” tab and then click the “Insert Scatter (X, Y) or Bubble Chart” in the “Charts” group. A drop-down menu will appear. Here, select the scatter plot style you’d like to use.

Once selected, the scatter plot will be inserted into the spreadsheet.

The data from our Value 1 column appears on the x-axis, and Value 2 on the y-axis.

Related: How to Make a Graph in Microsoft Excel

Format Your Scatter Plot

If you need the scatter plot to match a specific style, you can change its design and format. To do so, click the scatter plot to select it and two new tabs will appear: Chart Design and Format.

In the Chart Design tab, you’ll find options to let you change the chart layout and style, switch the row and column of data, and completely change the chart type if you happened to choose the wrong one initially. For example, if you want to change the chart style to a predefined style, select a style you like in the “Chart Styles” group.

Once selected, the change will happen automatically.

In the Format tab, you can change the fill, outline, and effects of the chart. For example, you can apply a glow effect around the graph. To do so, click “Shape Effects” in the Shape Styles group.

Hover your cursor over “Glow” and then select an option from the Glow Variations group in the sub-menu. We’ll select the third orange option in this example.

The effect will be applied once selected.

That’s all there is to it. Keep tweaking the formatting options until you have a chart that fits your overall style.

Related: How to Create a Chart Template in Microsoft Excel