Data Analysis Tool
Example 1: Create an graph with three scatter plots on the same Excel chart based on the data in Figure 1.
Press Ctrl-m to open the interface to the Real Statistics data analysis tools. Choose the Compound Scatter Chart option from the Desc tab. Next, fill in the dialog box that appears as shown on the right side of Figure 1.
Figure 1 – Chart data
After clicking on the OK button, the chart shown in Figure 2 is displayed.
Figure 2 – Chart output
To enlarge the chart in Figure 2, we click on the chart and then press Ctrl-m to reopen the interface to the Real Statistics data analysis tools. This time, we choose the Change Chart Axes Min/Max option from the Desc tab, and then fill in the dialog box that appears as shown in Figure 3.
Figure 3 – Revised chart axes bounds
After clicking on the OK button, the chart in Figure 2 changes to that shown in Figure 4.
Figure 4 – Enlarged chart
Examples Workbook
Click here to download the Excel workbook with the examples described on this webpage.
Reference
Wikipedia (2012) Scatter plot
https://en.wikipedia.org/wiki/Scatter_plot#:~:text=A%20scatter%20plot%20(also%20called,for%20a%20set%20of%20data.