Have several series of data I want to plot on the same chart:

Series A
X Y
4015188 7361762
4020374 9581526
4022289 10649655
4023878 11223132
4025512 12035416
4028600 13408580
4030353 14233259
Series B
X Y
689673 10918805
691097 11241203
691632 11510570
692105 11779503
692555 12044321
693475 12574225
694068 12847928
694512 12874474
695523 13412715
696015 13681729
696525 13950947
698062 14758546

So want to plot these as scatter/line graph, on the X/Y axis. Each series should be represented by a different color. How do I do this?

3 Answers

An alternative... Adjust your data:

 Series A
4015188 7361762
4020374 9581526
4022289 10649655
4023878 11223132
4025512 12035416
4028600 13408580
4030353 14233259 Series B
689673 10918805
691097 11241203
691632 11510570
692105 11779503
692555 12044321
693475 12574225
694068 12847928
694512 12874474
695523 13412715
696015 13681729
696525 13950947
698062 14758546

Select the series A data, including the first row with the blank cell and "Series A" label, and insert your XY Scatter chart, using the option with lines and markers.

Select and copy the series B data, including the first row with the blank cell and "Series B" label, select the chart, and click on Paste Special from the Paste button down arrow on the Home tab. Choose New Series, Values in Columns, Series Names in First Row, and X Values in First Column.

I've recently written Multiple Series in One Excel Chart, a tutorial describing this technique.

Here is one solution; discuss:

X Y1 Y2
4015188 7361762
4020374 9581526
4022289 10649655
4023878 11223132
4025512 12035416
4028600 13408580
4030353 14233259
689673 10918805
691097 11241203
691632 11510570
692105 11779503
692555 12044321
693475 12574225
694068 12847928
694512 12874474
695523 13412715
696015 13681729
696525 13950947
698062 14758546

Excel will happily plot this.

This is essentially the same answer as this one above, but using Office365Pro,
Excel Version 2002 Build 12527.21236

Step by step

• Arrange data in separate junks like in the example below.
• Select one of those

• Insert a default XYScatter plot

• Right click the data area of the plot and select Select Data...

• Click the Add button to add a series

• Use the pop-up dialog to specify the three ranges for the label, the X and the Y values

That's it.

Note one pit-fall: If your X-values contain non-numeric fields, then the whole x-axis will be interpreted as counted and you might see a plot like this: