sharepoint 2013 chart with the list data

I have a Sharepoint 2013 list with multiple columns like lookup and other columns. I need to insert multiple charts based on this data. I am not able to edit the list using the excel web services with the error not able to open the list. Can somebody please help me with this. Thanks in advance.

Note : I am allowed use only the native sharepoint tools.

Regards,

Shivakumar