It also includes information for Android and iOS devices.
Scatter charts are sometimes called X and Y charts, scatter plots, scatter diagrams, or scatter graphs.
A scatter chart helps you compare pairs of values and understand the relationship between two variables.
To create a scatter plot in Excel on laptop or desktop systems, run with this.
Check your data set to check that you have at least two columns (or rows) of data.
InCharts, select theScatter (X, Y) or Bubble Chartdropdown.
SelectMore Scatter Chartsat the bottom of the menu.
opt for Scatter chart option you prefer.
grab the chart style, then selectOK.
Excel should now have inserted a chart into your spreadsheet that displays your data.
However, in most cases, youll need to adjust one or more chart elements.
Click (or tap) on blank space in the chart to go for the chart.
Next, adjust chart element display options.
pick the+key next to the chart to choose which chart elements display.
Next to each element, if you snag the checkbox, the item will display.
Deselect the checkbox to hide an element.
Select to the right of an element name to see a triangle that allows access to additional element options.
In almost every case, you should enableAxes,Axis Titles,Chart Title, andGridlines.
If desired, with the chart selected, selectChart Styles(paintbrush) to adjust appearance.
When complete, click (or tap) once on the chart to select it.
Once selected, you may move the chart anywhere on the current sheet.
it’s possible for you to resize the chart by selecting and moving any of the chart corners.
You may also useCtrl+Cto copy the chart, thenCtrl+Vto paste the chart elsewhere in your Excel spreadsheet.
(Denoted by a small circle.)
On larger devices, such as a tablet, tapInsert>Charts>X Y (Scatter).
Scroll down toChartand select.
Scroll down and selectX Y (Scatter).
choose the Scatter chart option you prefer.
Excel should now have inserted a chart into your spreadsheet that displays your data.
(Those options will be grayed out.)
The process for creating a scatter plot on mobile, laptop, and desktop systems is remarkably similar.
drop your data, select it, insert a chart, then adjust the chart details.
