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

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

Daniel Lv12

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

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.

Highlighted plot data.

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.

Select a scatter plot.

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

A scatter plot in Excel.

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.

The Chart Design and Format tabs.

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.

Change the chart style.

Once selected, the change will happen automatically.

The chart after changing the design.

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.

Click shape effects.

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.

Apply a glow effect.

The effect will be applied once selected.

A chart with the glow effect.

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

  • Title: Mastering Data Visualization: How To Craft Scatter Plots with Microsoft Excel
  • Author: Daniel
  • Created at : 2024-08-27 23:56:52
  • Updated at : 2024-08-28 23:56:52
  • Link: https://win-answers.techidaily.com/mastering-data-visualization-how-to-craft-scatter-plots-with-microsoft-excel/
  • License: This work is licensed under CC BY-NC-SA 4.0.