How Excel draws two types of data on the same image

. Looking at the table below, there are three columns of data, the independent variable X and the two dependent variables y1 and y2. We want to use scatter plots to represent the relationship between x and y1. Using a scatter plot to represent the relationship between x and y2, how do you plot two scatter plots on one graph? First draw the first curve, select the two columns x and y1 data, then select a scatter plot, right click on the chart as shown in the figure, click [Select Data] We see the [Data Source] dialog box open. Click the [Add] button to edit the data series. You can see that I have different data sources in different colors. You can follow the arrow to operate. This is my designed data series. Click OK to return to the Data Source dialog box. We clicked the OK button and two curves have appeared. We click the [Add] button and select Add [Legend] as shown, so that you can know who the two curves represent. "Microsoft Office2015 official latest version download" This article comes from [system home] www.xp85.com