An Excel scatter chart visually displays data points on a grid, with each point determined by values on the x-axis and y-axis. This type of Excel graph is handy for illustrating the relationship between two variables. The horizontal axis shows control parameters or independent variables, while the vertical axis represents measured or dependent variables.

In Scatter Charts within Excel, you can use dots, lines, and bubbles. Dots are straightforward representations, while lines offer a visual similar to line charts.. Bubbles, however, add another layer, allowing you to incorporate a set of variables to showcase diverse-sized bubbles, indicating a second magnitude.

 

Scatter Chart Basics

Sections

In Excel, a Scatter Chart comprises five key sections:

1. Plot Area: This is where the actual visual representation happens. Your data points can be dots, lines, or bubbles, each with distinct colors to differentiate series.
2. Chart Title: Think of it as the name tag for your chart, summarizing what the visualization is about.
3. Y-Axis (Vertical): This is the up-and-down axis, showcasing your dependent variables or measures. In a sample chart, these can be grouped differently for clarity.
4. X-Axis (Horizontal): The left-to-right axis, representing independent variables or control parameters. It sets the context for your data points.
5. Legend: Acting like a guide, the legend distinguishes between various data series, helping you interpret the information easily.

In Excel, these elements come together to create effective Scatter Charts, making data visualization a breeze.

Types

The data of a scatter chart can be displayed with dots (markers), lines, and bubbles. You can also choose between straight and smooth lines, and marker types.

• Scatter: This is the traditional scatter chart type. Each dot represents a variable in the form of coordinates. Different colors mean different variables (series).
• Smooth Lines and Markers: This type looks like a line chart with markers (dots). The variable markers are connected with a smooth line. You can make the line straight or remove the markers altogether. This type works best if you have fewer data points in your table.
• Bubble: A Bubble chart can be used to indicate the value of another variable in the given coordinates. Larger bubbles indicate larger values.

 

Insert a Scatter Chart

Start by selecting your data in Excel. Including data labels in your selection will be automatically recognized by Excel.

Go to the Insert tab in the Ribbon and click on the Scatter Chart icon to see the available chart types. Click on the desired chart type to insert. In this example, we’re going to be using Scatter.

Clicking the icon inserts the default version of the chart. Now, let’s look at how you can customize the chart.

 

Customize Your Scatter Chart

You can edit almost any element in a chart, and there are a few ways to do so. All methods will yield pretty much the same results.

Double-Clicking

Double-clicking on a chart area item will pop up the side panel that contains options for the selected element. Keep in mind that you don't need to double-click another element to switch to another once the side panel is open. Selecting the other item while this window is active will switch to that element.

Side panel includes element specific options as well as generic options like coloring and effects.

Right-Click (Context) Menu

Right-clicking an element displays the context menu. You can modify basic styling properties like colors, delete items, or activate the side panel for more options. To display the side panel, choose the option that starts with “Format” (i.e. Format Data Series…).

Chart Shortcut

You can add/remove elements, apply predefined styles and color sets and filter values using shortcuts. Furthermore, you can see the effects of these options on the fly before actually applying them. For example. in the following image the mouse is on the Data Labels item and the chart labels are shown.

Ribbon (Chart Tools)

Whenever you activate a special object, Excel adds a new tab(s) to the Ribbon. You can see these chart specific tabs under CHART TOOLS. There are 2 tabs: DESIGN and FORMAT. While the DESIGN tab contains options to add elements, apply styles, modify data and modify the chart itself, the FORMAT tab provides more generic options that are common with other objects.

 

Customization Tips

Preset Layouts and Styles

Preset layouts are always a good place to start for detailing your chart. You can find styling options from the DESIGN tab under CHART TOOLS or by using the brush icon on Chart Shortcuts. Below are some examples.

Applying a Quick Layout:

Changing colors:

Updating the Chart Style:

Changing chart type

You can change the type of your chart any time from the Change Chart Type dialog. Although you can change your chart to any other chart type, in this example we’re going to focus on Area chart variations.

To change the chart type, click on the Change Chart Type items in Right-Click (Context) Menu or DESIGN tab.

In the Change Chart Type dialog, you can see the options for all chart types with their previews. You can also find the options to add or remove markers, and change line types. Select your preferred type to continue.

Switch Row/Column

B y default, Excel assumes that vertical labels of your data are the categories, and the horizontal ones are the data series. If your data is reversed, click Switch Row/Column button in the DESIGN tab, when your chart is selected.

Move a chart to another worksheet

By default, charts are created inside the same worksheet as the selected data. If you need to move your chart into another worksheet, use the Move Chart dialog. Begin by clicking the Mover Chart icon under the DESIGN tab or from the right-click menu of the chart itself. Please keep in mind you need to right-click in an empty place in chart area to see this option.

In the Move Chart menu, you have 2 options:

• New sheet: Select this option and enter a name to create a new sheet under the specified name and move your chart there.
• Object in: Select this option and select the name of an existing sheet from the dropdown input to move your chart to that sheet.

In conclusion, Excel's Scatter Chart proves to be an indispensable feature for visually interpreting data relationships. With its user-friendly interface and versatile chart types—dots, lines, and bubbles—it provides a dynamic platform for showcasing the correlation between two variables. Understanding the essential sections, including the Plot Area, Chart Title, Y-Axis, X-Axis, and Legend, ensures effective communication of data insights.

The straightforward process of inserting and customizing Scatter Charts, whether through double-clicking, right-clicking, or using the Ribbon, empowers users to tailor visualizations to their specific needs. Excel's array of customization options, from preset layouts to changing colors and updating styles, enhances the aesthetic appeal of charts, making data analysis accessible and impactful. Overall, the Scatter Chart in Excel is not just a graphical representation but a powerful tool that democratizes data-driven decision-making.