This article explains how to create a scatter chart in Excel for Windows and Mac computers. It also includes information for Android and iOS devices. The instructions apply to Excel 2019, 2016, 2013, 2010, Excel 2016, 2011 for Mac, Excel 365, and Microsoft Excel on Android and iOS.
How to Make a Scatter Chart in Excel
In Excel, a scatter chart displays data points positioned at coordinates on an x-axis and y-axis. Scatter charts are sometimes called X and Y charts, scatter diagrams, scatter charts, or scatter graphs.
A scatter chart helps you compare pairs of values and understand the relationship between two variables. Follow these steps to create a scatter chart in Excel on laptop or desktop systems.
Check your dataset to make sure you have at least two columns (or rows) of data. Ideally, the first cell in each series contains a text entry that describes the numbers that follow, such as "Car Mileage" or "Annual Maintenance Cost."
