![]() ![]() Select the data, including the headers (the titles at the top of the columns).How to Quickly Create an XY Chart in Excel To put the finish touches on the plot (the graph and axes label), click on the chart. Scatter plots are often used to find out if there's a relationship between variable X and Y.Īfter you click OK again, you have an Excel Chart that looks like this: 8. Use a scatter plot (XY chart) to show scientific XY data. Copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data you want to plot in a scatter chart. ![]() ![]() › ~dleeling › statistics › xyscattergraph. Choose a linear regression and then click on the Options tab. Click on a point on the chart to highlight the data points. Select the data and click on the chart wizard button.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |