A scatter plot is the best way to identify patterns, trends, or correlations between two sets of data. Follow these steps to create one quickly in Excel.
Để AI làm thayChọn dữ liệu của bạn
Highlight the two columns of numerical data you want to plot, ensuring the independent variable is in the left column.
Insert the chart
Go to the 'Insert' tab on the ribbon, click the 'Insert Scatter (X, Y) or Bubble Chart' icon, and select the first 'Scatter' option.
Customize the chart
Use the 'Chart Elements' button (plus icon) to add axis titles, a chart title, or trendlines to improve readability.
This usually happens if your data is formatted as text instead of numbers, or if you selected only one column of data.