How to create automatic chart???

[xymcrush17]

Hi mr excel.
I select data and Series on ROw 2 for chart 1.
So when I create chart 2 I copy paste chart 1 and change series on ROW 3.

so the problem is i have 1000 rows data. and it waste time when using my way.

is there any way faster?

 

[xymcrush17]

thanks in advance

 

[xymcrush17]

any helps please