Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: Scatter Chart

Create Scatter Chart in Excel

Use a¬†scatter chart¬†(XY chart) to show scientific XY data. Scatter charts are often used to find out if there’s a relationship between variable X and Y. Straight Lines To create a scatter chart, execute the following steps. 1. Select the range A1:D22. 2. On the Insert tab, in the Charts group, click the Scatter symbol. 3. Click Scatter with Straight…