How to Create XY Chart in Excel

An XY chart is one of the most effective ways to see how two different numbers relate to each other. You might know it as a scatter plot or scatter graph, but whatever you call it, its job is to help you uncover patterns in your data. This guide will walk you through exactly how to create and customize an XY chart in Excel, step-by-step.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is an XY Chart?

An XY chart, or scatter plot, plots data points on a horizontal (X) and vertical (Y) axis to show the relationship between two sets of numbers. Each dot on the chart represents a single data point with two values: its X-axis coordinate and its Y-axis coordinate.

The whole point is to see if there's a correlation. For example, you could plot your daily advertising spend (X-axis) against your daily website visitors (Y-axis). By looking at the pattern of the dots, you can quickly determine if spending more on ads generally leads to more visitors.

When should you use an XY chart?

Use an XY chart when you want to answer questions about the relationship between two numerical variables:

• Positive Correlation: As one variable increases, the other variable also tends to increase. The dots on the chart will generally slope upwards from left to right. (e.g., more hours studying leads to higher test scores)
• Negative Correlation: As one variable increases, the other variable tends to decrease. The dots will slope downwards from left to right. (e.g., higher product price leads to fewer sales)
• No Correlation: There is no discernible relationship between the two variables. The dots will be scattered around the chart with no clear pattern. (e.g., the daily temperature has no effect on your website’s conversion rate)

It's important not to confuse a scatter plot with a line chart. A line chart is best for tracking a single value over a continuous period, like website traffic over the past 30 days. An XY chart is for comparing two separate variables to see if they move in tandem.

Preparing Your Data for an XY Chart

Excel makes creating charts easy, but only if your data is set up correctly first. For an XY chart, the structure is simple and specific: you need two columns of numerical data, side-by-side.

The variable you believe is a potential cause or is the one you control (the independent variable) should be in the left column. This data will be on your horizontal X-axis. The variable that might be the effect (the dependent variable) should be in the right column and will go on your vertical Y-axis.

Imagine we're marketers looking at daily blog stats. We want to see if the number of words in an article correlates with the number of shares it gets. Our data would look like this:

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Example Data Structure:

In your spreadsheet, you'd likely have:

• Column A: Word Count (our X-axis, the independent variable)
• Column B: Social Shares (our Y-axis, the dependent variable)

Your sheet would be set up something like this:

Before you build your chart, quickly scan your two columns to make sure they contain only numbers and that there are no gaps or empty cells in the middle of your dataset. Formatting errors can prevent Excel from creating the chart correctly.

How to Make an XY Chart in Excel: A Step-by-Step Guide

Once your data is clean and organized, creating the chart takes less than a minute. Follow these simple steps.

Step 1: Select Your Data

Click and drag your mouse to highlight both columns of data you want to plot. Make sure you include the headers (like "Word Count" and "Social Shares"). Including headers tells Excel to autofill them as your series name or chart title later on, saving you a step.

Step 2: Insert the Scatter Chart

With your data selected, go to the Insert tab on Excel’s ribbon.

In the Charts section, look for a small icon that looks like a plot with scattered dots. This is the Insert Scatter (X, Y) or Bubble Chart icon. Click on it.

Step 3: Choose Your Chart Type

A dropdown menu will appear with several chart options. For a standard XY chart, you’ll typically choose the first one, simply labeled Scatter. This will plot your data points as individual markers without any connecting lines.

The options with lines ("Scatter with Smooth Lines" or "Scatter with Straight Lines") are useful in certain cases, but they can be misleading if your data isn't sorted along the X-axis. It's usually best to start with the simple scatter plot and add a trendline later if needed.

As soon as you select it, Excel will immediately generate your XY chart and place it on your worksheet.

Customizing Your XY Chart for Clarity and Impact

The default chart Excel creates is a great start, but it needs a bit of customization to make it professional and easy to understand. Here are the most important adjustments to make.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

1. Add Chart and Axis Titles

A chart without labels is just a collection of dots. You need to give it context. Click anywhere on your chart to make the Chart Design tab appear in the ribbon.

• Navigate to Chart Design > Add Chart Element.
• Select Chart Title > Above Chart and give your chart a descriptive name, like "How Word Count Correlates with Social Shares."
• Go to Add Chart Element > Axis Titles > Primary Horizontal. Name your X-axis (e.g., "Word Count").
• Go back to Add Chart Element > Axis Titles > Primary Vertical. Now you can describe your Y-axis data (e.g., "Number of Social Shares").

Pro Tip: You can also use the green "+" icon that appears on the top right-hand side of your chart when it's selected. Clicking it brings up a checklist of all the key chart elements you can toggle on or off, including Axis Titles, Chart Title, and more. A chart's not finished until these labels are on it.

2. Add a Trendline to Show Correlation

A trendline is a straight or curved line that shows the general direction of your data. It's the best visual tool for understanding the underlying correlation.

To add one, simply right-click on any of the data points in your chart and select Add Trendline... from the dropdown menu.

The "Format Trendline" pane will open on the right. For most business use cases, a Linear trendline is the perfect choice. You’ll see the line added to your chart immediately. If it slopes up, you have a positive correlation. If it slopes down, the correlation is negative.

3. Adjust the Axes for a Better View

Sometimes, your data points can be clustered in one area of the chart, leaving a lot of empty white space. You can fix this by adjusting the axis bounds.

For example, if your lowest Y-axis value (Social Shares) is 110, you don't need the axis to start at 0.

Right-click on the vertical (Y) axis and choose Format Axis... In the pane that opens, you can manually set the Minimum Boundary. Adjusting it to a value like 100 can make the pattern much clearer.

4. Format Your Chart's Appearance

Finally, clean up the visual elements to match your company’s branding or just to make the chart look cleaner.

• Data Markers: Right-click on a data point and select Format Data Series... Here you can change the marker's shape, color, and size.
• Gridlines: Some people find gridlines distracting. You can remove them by clicking on them and hitting the 'Delete' key, or by using the green "+" icon.
• Colors and Fonts: Use the Chart Design tab to explore different pre-set styles or change the color palette for your entire chart to align with brand colors.

A few small formatting changes can transform a basic chart into a polished, professional visualization that is ready for your presentation or report.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Common Mistakes to Avoid

Creating an XY chart is straightforward, but a few common slip-ups can lead to confusing or misleading visuals. Here are two big ones to watch out for:

1. Using a Line Chart Instead of a Scatter Plot: Excel’s "Line Chart" option can create a similar-looking graph, but it operates differently. A line chart connects data points in the order they appear in your columns, assuming the X-axis is a sequence (like dates January, February, and March). A scatter plot treats the X and Y variables as independent coordinates. Using a line chart can lead to an unusable, jagged mess rather than uncover any potential relationships.

2. Assuming Correlation Means Causation: This is the most critical data interpretation mistake. Your XY chart may show a stunningly clear positive correlation between two variables, but that does not prove that one thing causes the other. A strong correlation is often enough for us to investigate which levers you can possibly begin to pull to see the needle move on your marketing campaign, and it can uncover a powerful connection but without additional, rigorous research, you should be cautious, as they might have just been pulled in a particular direction together.

Final Thoughts

Creating an XY chart in Excel is an invaluable skill for anyone wanting to find the hidden stories within their data. By correctly preparing your data, inserting a scatter plot, and making a few key customizations, you can quickly build powerful visualizations that reveal the relationship between key business metrics.

Mastering charts in Excel and Sheets is fantastic, but when you're pulling data from HubSpot, Google Ads, GA4 on top of your existing sheets it can slowly spiral into a full-time, manual reporting process. That's why we built Graphed. We automate the mundane weekly charting chore and reporting by connecting directly to your favorite marketing and business tools, and we'll instantly create up-to-the-minute charts and dashboards of virtually any combination of your company metrics by taking simple, plain English instructions for exactly what it is you want, without opening up another sheet again.