Chart - Automatically detect series

[Siggi335]

Hi!!

Suppose you have some XY data you would like to plot in a scatter chart

I have 3 data sets that are all independent as illustarated below

Is it possible to create a chart that displays the XY values based on the selected set?

I.e. to automaticlly have excel recognize a set to be a "series" with the assosiated XY values

(my real case has 68sets and over 11k rows in total)

Set	X-Value	Y-value
A	1	0.645267
A	2	0.764317
A	3	0.976887
A	4	0.420331
B	2	0.833436
B	4	0.978825
B	6	0.956257
B	8	0.616265
C	1	0.882638
C	3	0.170607
C	5	0.07735
C	7	0.384577

Regards

[#2]

@Siggi335 

Excel cannot detect that automatically. You'd have to organize the data differently, with a separate column for each set:

Excel will then create the correct chart: