Chart - Automatically detect series

Occasional Visitor

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)

 

SetX-ValueY-value
A10.645267
A20.764317
A30.976887
A40.420331
B20.833436
B40.978825
B60.956257
B80.616265
C10.882638
C30.170607
C50.07735
C70.384577

 

Regards

 

 

1 Reply

@Siggi335 

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

S1828.png

Excel will then create the correct chart:

S1829.png