How does excel make scatter graphs?

Excel scatter charts are slightly different from other chart types, and you can select all the data and not generate scatter charts for multiple sets of data.

1, the following figure B:c Two column is a set of data, e:f Two column is another set of data, the production method is as follows:

2, select b:c Two column data, do not bring the title section, insert scatter plot:

3, modify the position of the axis labels, the XY axis of the label on the lowest and leftmost, at this time the chart is as follows:

4, in the drawing area of the right key selection: Select the data, and in the pop-up dialog box select: Add

5, respectively, the e-column data added to the x-axis series values, f column data added y-axis series values, and click OK, the original dialog box in a more than one: series 2, click to determine the completion of the addition of data.

6, the following figure: Two series of scatter chart is completed.