How to Create a Scatter Graph in Microsoft Excel (2026)
Learn how to make a scatter graph in Excel step by step. Insert XY plots, add trendlines, label points, and fix common chart problems fast.

Microsoft Excel: upcoming dates and official changes
- Jun 30, 2026: Certiport retired the Microsoft Office Specialist 2016 certifications, including MOS Excel 2016, on June 30, 2026. The Microsoft 365 Apps and Office 2019 Excel exams are still available. (certiport.pearsonvue.com)
- Updated Oct 16, 2026: Delivery is now Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) (previously Proctored live-in-the-application exam via Certiport Authorized Testing Centers).
- Updated Oct 16, 2026: Eligibility is now No formal prerequisites; about 150 hours of instruction and hands-on experience recommended (previously No formal prerequisites; ~150 hours of instruction and hands-on experience recommended (Associate)).
- Updated Oct 16, 2026: Time limit is now 50 minutes (60 minutes seat time) (previously 50 minutes (60 minutes seat time)).
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
- The MOS Excel (Microsoft 365 Apps) exam has 33 to 37 questions. (certiport.pearsonvue.com)
- The MOS Excel Expert (Microsoft 365 Apps) exam has 23 to 27 questions. (certiport.pearsonvue.com)
- Microsoft Office Specialist Excel exams last 50 minutes, with 60 minutes of total seat time. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- The passing score for Microsoft Office Specialist Excel exams is always 700 on Certiport's 1 to 1000 scaled score. (certiport.pearsonvue.com)
- After failing a Microsoft Office Specialist Excel exam, candidates must wait 24 hours before the first retake and 48 hours before each later retake, and there is no annual limit on attempts. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Microsoft Office Specialist Excel certifications earned on or after September 23, 2025 are valid for five years; those earned earlier do not expire. (certiport.pearsonvue.com)
- The Microsoft Office Specialist Excel exam is proctored and delivered live in the Excel application through Certiport Authorized Testing Centers, either in person or remote-proctored. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Microsoft recommends that candidates for the MOS Excel Associate (Microsoft 365 Apps) certification have about 150 hours of instruction and hands-on experience with Excel. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Candidates get their MOS Excel score report as soon as they finish the exam, and it can also be viewed in their Certiport profile. (certiport.pearsonvue.com)
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
Microsoft Excel Exam at a Glance
| Item | Detail | Official source |
|---|---|---|
| Number of questions (Excel Associate (MO-210)) | 33-37 questions | certiport.pearsonvue.com |
| Number of questions (Excel Expert (MO-211)) | 23-27 questions | certiport.pearsonvue.com |
| Time limit | 50 minutes (60 minutes seat time) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Passing score | 700 on a 1โ1000 scale | certiport.pearsonvue.com |
| Retake policy | Wait 24h after 1st fail, 48h before each later retake; no annual limit | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Validity | Valid 5 years (earned on/after Sept 23, 2025) | certiport.pearsonvue.com |
| Delivery | Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Eligibility | No formal prerequisites; about 150 hours of instruction and hands-on experience recommended | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Score release | Score report at end of exam; also in Certiport profile | certiport.pearsonvue.com |
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
To create a scatter graph in Microsoft Excel, select two numeric columns (X on the left, Y on the right), then click Insert > Charts > Scatter: three clicks.
A scatter graph in Excel plots two numeric variables against each other and reveals patterns the eye cannot pick out from a column of numbers. It is the chart of choice when you want to see if hours studied predicts test scores, if ad spend tracks with revenue, or if temperature explains energy use. Practice with the free Excel practice test on PracticeTestGeeks (500+ questions with answer explanations).
The basic mechanic is simple. Highlight two columns of paired data, open the Insert tab, click the chart icon that looks like dots on a grid, and Excel draws an XY plot. The first column maps to the horizontal axis, the second column maps to the vertical axis, and each row becomes one point.
What trips most people up is not the insert step. It is what comes after. Picking the right scatter variant out of five options, labeling individual points, swapping the axes when Excel guesses wrong, and stacking a trendline on top to quantify the relationship. Those are the moves that turn a default chart into something you can present.
This guide walks through every step in order. By the end you will be able to build a clean scatter plot, switch between marker-only and line-connected styles, add a regression trendline with an R squared value, and rescue a chart that came out empty or upside down. The instructions cover Excel 2016 through Microsoft 365 on both Windows and Mac.
Before opening Excel, decide what question you want the chart to answer. A scatter plot answers questions of the form "does X predict Y?" or "are these two measurements related?" If your question is about how a quantity changes over time, you probably want a line chart instead. If it is about comparing categories, a bar chart will serve you better. The chart type should match the question, not the other way round.
Free Excel Study Tools
Interactive Excel resources on PracticeTestGeeks, free to start:
- Free Excel Questions and Answers โ 16 questions with instant scoring and answer explanations
- Excel flashcards โ review key terms and concepts card by card
- Excel study guide โ topic-by-topic overview of what the exam covers
- Excel cheat sheet โ one-page printable summary for last-minute review
Studying for certification? Microsoft's official MO-210 Excel (Microsoft 365 Apps) exam page lists "Manage charts" among its five skill areas and gives a 50-minute time limit, and Certiport's exam-lengths page puts the exam at 33-37 questions.
Scatter Chart at a Glance

Fastest method: Select two columns of numbers with the X variable on the left and the Y variable on the right, then press Alt + F1 for a default chart or use Insert > Charts > Scatter. Excel auto-detects ranges if you click any cell inside the data block before inserting.
Six Steps to a Basic Scatter Graph
Start by laying out your data in two adjacent columns. The independent variable goes on the left (Excel reads this as the X axis), and the dependent variable goes on the right. Headers in row one are optional but recommended because Excel uses them for the chart title.
Highlight the entire range including headers. A common mistake is selecting only one column and wondering why the chart looks like a flat line. Both columns must be in the selection.
Go to the Insert tab on the ribbon. In the Charts group, find the icon that looks like four dots arranged in a square. Hover over it and you will see Insert Scatter (X, Y) or Bubble Chart. Click the small arrow to open the gallery.
Pick the first option, plain Scatter, which shows only markers. Excel draws the chart on the active sheet. Drag it to where you want it or cut and paste onto a dashboard tab.
Right-click any marker and choose Add Trendline if you want a regression line. The trendline pane on the right lets you pick linear, exponential, logarithmic, polynomial, power, or moving average. Tick Display Equation on chart and Display R-squared value to show the formula and goodness of fit.
Click the chart title and type something descriptive. Click the axis numbers to format them, set minimum and maximum bounds, and choose decimal places. This last step matters because Excel often picks ugly defaults like 0.000001 increments.
If the keyboard is faster for you, the shortcut Alt + F1 inserts a default chart embedded on the current sheet. F11 inserts a chart on its own dedicated sheet. Excel will guess the chart type based on your data shape, so two numeric columns usually produce a scatter, but mixed text and number columns sometimes default to a clustered column. You can swap the chart type after insertion through the Chart Design ribbon tab.
Five Scatter Chart Variants
The plain scatter plot. Each row becomes one dot. No lines connect the points. This is the default and the right choice for showing relationships between two variables when there is no time sequence to preserve. Use it for correlation studies, dose-response curves, and any plot where the X axis is not time.

Fixing the X and Y Axis When Excel Guesses Wrong
Excel does not always read your data layout correctly. When the chart looks scrambled, the usual culprit is column order. The leftmost selected column becomes X, the rightmost becomes Y. If you want to flip them, the cleanest fix is to rearrange the source columns, but there is a faster way that does not touch the data.
Right-click the chart and choose Select Data. The dialog shows a series with X Values and Y Values fields. Click Edit. Cut the X Values reference and paste it into Y Values, then point X Values at the other column. Excel redraws the chart with axes swapped.
Another common axis problem is when one variable spans a huge range and the other does not. The chart looks like a vertical line because Excel auto-scales both axes to fit. Right-click the offending axis, choose Format Axis, and set a logarithmic scale. This compresses the wide-range axis and makes the relationship visible. Engineering and finance datasets benefit from log scales almost every time.
If you have negative values that should sit on the left side of the chart, untick Values in reverse order or set the Minimum bound manually. Excel sometimes flips axes when it detects a particular data shape, and the reverse-order toggle catches that case.
The crossing point of the axes matters too. By default both axes cross at zero, which can push your data into one quadrant of the chart while leaving the rest empty. In the Format Axis pane, find Vertical axis crosses and set it to At axis value, then type a number near the minimum of your X data. The result is a tighter plot with no wasted space and a clearer view of where points cluster.
When to Pick a Scatter Plot
Two variables, suspected relationship
- โธHours studied vs test scores
- โธCalories vs body weight
- โธAd spend vs revenue
- โธSleep hours vs productivity score
Measurements with continuous X values
- โธTemperature vs pressure
- โธDistance vs velocity
- โธConcentration vs absorbance
- โธTime vs decay rate
Performance pairs to compare
- โธPrice vs demand
- โธHeadcount vs output
- โธCustomer age vs spend
- โธMarketing spend vs leads
Use a different chart instead
- โธCategorical X (use a column chart)
- โธSingle time series (use a line chart)
- โธPart-of-whole data (use a pie or stacked bar)
- โธDistributions (use a histogram)

If your scatter plot inserts but shows nothing, Excel probably read your numbers as text. Select the column, click the small warning icon, and choose Convert to Number. Or use the text-to-number conversion methods covered in the dedicated guide. Charts redraw automatically once the data type changes.
Adding a Trendline and Reading the R-Squared
A trendline is a regression line fitted to your data. It shows the overall direction and lets you predict values that fall between or beyond the measured points. Excel offers six trendline types, and picking the right one matters more than most people realize.
Linear is the default and the right choice when the relationship looks like a straight line through the cloud of points. The equation Excel displays will be in the form y equals m x plus b, the same slope-intercept format taught in algebra class.
Exponential fits curves that grow or decay at a constant percentage rate. Population growth, compound interest, and radioactive decay follow this pattern. The equation comes out as y equals a times e to the power of b times x.
Polynomial trendlines bend to follow more complex shapes. You set the order from 2 to 6. Order 2 is a parabola, order 3 has one inflection point, and so on. Be careful with high orders because the curve will fit your data perfectly while saying nothing useful about the underlying pattern. This is overfitting in plain sight.
The R-squared value tells you what fraction of the variation in Y the trendline explains. Multiply by 100 to read it as a percentage. R-squared of 0.85 means the line accounts for 85 percent of the up-and-down movement in your data. Above 0.7 is usually considered a strong fit. Below 0.3 means the variables may not be related at all, or the relationship is non-linear and a different trendline type would do better.
Moving average is the odd one out. It is not really a regression in the same sense as the others. Excel draws a smoothed line by averaging a set window of points and sliding it across the data. The Period setting controls the window size. Use it when you want to dampen noise and see the underlying trend in a noisy time-ordered series. Moving averages do not produce an equation or an R-squared, so they cannot be used for prediction.
Logarithmic and power trendlines round out the toolkit. A logarithmic fit suits data that rises quickly and then levels off, like learning curves where each hour of practice produces a smaller gain than the last. A power fit handles data where both X and Y vary over several orders of magnitude, which is common in physics, biology, and economics. Try each one, compare R-squared values, and pick the model with both the highest R-squared and the simplest form that still makes sense for your data.
Pre-Share Checklist for a Scatter Chart
- โBoth axes have descriptive titles with units (kg, dollars, hours)
- โChart title states what is being compared, not just the data range
- โMarker size is large enough to see at presentation distance
- โAxes are scaled to start near the data, not at zero unless meaningful
- โOutliers are labeled or annotated if they will distract the reader
- โTrendline equation and R-squared are visible if a regression is shown
- โLegend is removed if there is only one series (it adds clutter)
- โGridlines are subtle or hidden so dots stand out
- โColors work in black-and-white print and pass color-blind safe checks
- โChart is saved as a template if the same style will be reused
Labeling Individual Points on a Scatter Plot
Excel does not let you label scatter points with a third column from the source data by default. You see this gap as soon as you try to label fifty cities by name on a population-versus-income chart. The built-in Data Labels feature only shows the X or Y numeric value, not your custom text.
The workaround takes two clicks. Add data labels through the chart elements menu, then with the labels still selected, open the Format Data Labels pane on the right. Tick the Value From Cells checkbox. A dialog pops up asking which range holds the labels. Point it at your column of names and click OK. Labels swap from numbers to text.
If the labels overlap, drag individual ones to the side. Excel remembers the positions. For tighter charts, set the label position to Above, Below, Left, or Right depending on point density. The leader lines option draws a thin connector from the label to its point, useful when you have to push labels far away.
Power users sometimes drop a screenshot of the chart into a tool like a slide deck and add labels with text boxes there. That works but the labels stop tracking the data if it changes. For anything you will update, keep labels native to the chart.
Another labeling tactic worth knowing is conditional labels. Suppose you only want to label the top five outliers, not every point. Build a helper column that uses an IF formula to return the name when a condition is true and an empty string otherwise. Point Value From Cells at that helper column instead of the full name list. Excel will leave most points unlabeled and only print the names where your formula said to. This keeps the chart readable when you have hundreds of points.
For very dense plots, consider color-coding by category and skipping individual labels entirely. Build a legend that maps colors to groups, and let readers spot patterns by region of color rather than by individual point name. Color-coding is more scalable than labeling once your dataset crosses a few dozen rows.
Scatter Plot Pros and Cons
- +Reveals correlations and outliers that tables hide completely
- +Works with any sample size from a handful of points to thousands
- +Trendlines turn the chart into a predictive model in two clicks
- +Multiple data series can overlay on the same plot for comparison
- +Logarithmic axes handle wide-ranging data like financial returns
- โCannot handle categorical variables on either axis
- โDefault Excel colors and styling look generic and need polishing
- โLabeling individual points requires a workaround Excel hides in menus
- โOverplotting hides density when points pile on top of each other
- โMisleading conclusions are easy if R-squared is reported without checking residuals
Pros and Cons at a Glance
| Pros | Cons |
|---|---|
| Reveals correlations and outliers that tables hide completely | Cannot handle categorical variables on either axis |
| Works with any sample size from a handful of points to thousands | Default Excel colors and styling look generic and need polishing |
| Trendlines turn the chart into a predictive model in two clicks | Labeling individual points requires a workaround Excel hides in menus |
| Multiple data series can overlay on the same plot for comparison | Overplotting hides density when points pile on top of each other |
| Logarithmic axes handle wide-ranging data like financial returns | Misleading conclusions are easy if R-squared is reported without checking residuals |
Multiple Series and Highlighted Subsets
One scatter plot can hold several data series. This is how you compare two groups on the same axes, like male versus female test scores or product A versus product B sales. The trick is to organize your data with the X column shared and separate Y columns for each group.
Select the X column and all Y columns at once. Excel will plot each Y column as a separate series, automatically colored. Use the Format Data Series pane to set distinct marker shapes (squares, triangles, diamonds) on top of the colors. Shape distinction matters for color-blind readers and for black-and-white printing.
To highlight a subset, like the top performers in a sales dataset, split your data into two columns. Put highlight values in column C with the rest in column B, leaving blank cells where the other group should be. Excel skips blanks and only plots the values that exist. Color the highlighted series in red or another standout shade.
For very large datasets, semi-transparent markers help with overplotting. Right-click the series, format the markers, and set fill transparency to 50 percent. The dense areas will appear darker because overlapping translucent dots add up. This is a free density map without writing any code.
Saving Your Chart as a Template
If you build the same kind of scatter plot repeatedly, save it as a template. Right-click the chart and choose Save as Template. Excel writes a .crtx file to the Templates folder. The next time you open the chart gallery, your saved style shows up under Templates at the top of the All Charts dialog.
Templates capture colors, fonts, axis settings, gridline visibility, and trendline preferences. They do not capture data, so applying a template to a new range gives you a freshly styled chart in one click. This is the move that turns weekly reporting from a half-hour formatting chore into a thirty-second job.
For deeper chart customization, see the related guide on creating any chart type in Excel which covers column charts, line charts, and pie variants alongside scatter. Pair it with the trendline-specific guide for regression details.
Avoiding the Most Common Scatter Plot Mistakes
The biggest mistake is reading correlation as causation. A strong line through the cloud means the two variables move together, not that one causes the other. Ice cream sales and drowning incidents both rise in summer, but ice cream does not cause drowning. Heat causes both. Always ask whether a third variable could be driving the pattern before drawing conclusions.
The second mistake is hiding small sample sizes behind a confident-looking trendline. Excel will happily fit a line to two points and report an R-squared of 1.0. That number is meaningless because two points always sit on a line. Aim for at least ten data points before treating a trendline as informative, and twenty or more before quoting an R-squared in a presentation.
The third mistake is letting a single outlier drag your trendline off the cloud. Always check whether removing one extreme point changes the slope dramatically. If it does, that single value is doing the explaining, not the underlying pattern.
Sample Excel Practice Questions
Try these questions from our free Excel practice tests. The correct answer and an explanation follow each question.
How do you create a spilling array formula in Excel 365?
- A. Press Ctrl+Shift+Enter
- B. Simply press Enter โ dynamic arrays spill automatically
- C. Wrap in ARRAYFORMULA()
- D. Select the output range first
Answer: B. Simply press Enter โ dynamic arrays spill automatically
In Excel 365, dynamic array formulas automatically spill results into adjacent cells when you press Enter.
What year was Microsoft Excel first released for the Macintosh?
- A. 1982
- B. 1985
- C. 1987
- D. 1990
Answer: B. 1985
Microsoft Excel was first released in 1985 for the Apple Macintosh, two years before the Windows version.
What is the purpose of IFERROR in Excel?
- A. Checks if a formula contains IF
- B. Returns a specified value if a formula evaluates to an error
- C. Logs errors to a worksheet
- D. Prevents incorrect formula entry
Answer: B. Returns a specified value if a formula evaluates to an error
IFERROR returns an alternative value if the formula results in any error type.
A user wants to create a formula that first calculates the total sales (Price * Quantity) and then applies a discount if the total is over $1,000. To avoid calculating the total sales twice within an IF statement, which function is most efficient for defining the total sales as a named variable within the formula?
- A. IFS
- B. LET
- C. VAR
- D. DEFINE
Answer: B. LET
The LET function is designed to declare and assign values to variables within a formula's scope. This improves readability and performance by preventing redundant calculations. The user can define 'TotalSales' as Price * Quantity once and then reference 'TotalSales' in the subsequent calculation.
Take the full Excel practice test
Excel Questions and Answers
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- learn.microsoft.com โ Retake policy, test delivery, time limit, eligibility ยท verified Oct 2026
- certiport.pearsonvue.com โ Exam format, score validity, passing score, score release, exam information ยท verified Oct 2026