Getting data from excel and making chart in word

Dear all

I am trying to get data from excel and make a chart in Word.

I have tried this code

Please Login or Register  to view this content.

and the data in excel is as under data range A1:E5)

s1 s2 s3
C1 20 25 30
C2 25 30 35
C3 30 35 40
C4 35 40 45

As it is a pie cgart range will be a1:b5
Kindly help in this matter

Thanks and regard

A type mismatch error occurred when setting the data rang (data range variable)