Load data from sharepoint list to excel and display in sharepoint page

%3CLINGO-SUB%20id%3D%22lingo-sub-1709885%22%20slang%3D%22en-US%22%3ELoad%20data%20from%20sharepoint%20list%20to%20excel%20and%20display%20in%20sharepoint%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1709885%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20create%20a%20some%20charts%20based%20on%20data%20that%20is%20stored%20in%20a%20sharepoint%20list.%20I%20can%20only%20use%20the%20%22Quick%20Chart%22%20Webpart%20in%20Sharepoint%2C%20our%20company%20does%20not%20want%20to%20install%20further%20webparts.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20possibilities%20with%20the%20%22Qucik%20Chart%22%20Webpart%20are%20not%20enough%20for%20me.%20So%20I%20had%20the%20idea%20to%20load%20the%20data%20to%20a%20excel%20worksheet%20to%20create%20my%20charts.%20As%20long%20as%20the%20file%20is%20stored%20on%20a%20local%20drive%20everything%20works%20fine.%20But%20if%20I%20upload%20the%20excel%20file%20to%20a%20sharepoint%20document%20library%20and%20show%20it%20in%20a%20sharepoint%20page%20via%20the%20Webpart%20%22document%20viewer%22%20the%20data%20connection%20is%20broken%20and%20I%20can%20not%20refresh%20my%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20there%20any%20possibilities%20to%20solve%20this%20problem%3F%3C%2FP%3E%3CP%3EThank%20you%20all%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1709885%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Hello,

 

I want to create a some charts based on data that is stored in a sharepoint list. I can only use the "Quick Chart" Webpart in Sharepoint, our company does not want to install further webparts.

 

The possibilities with the "Qucik Chart" Webpart are not enough for me. So I had the idea to load the data to a excel worksheet to create my charts. As long as the file is stored on a local drive everything works fine. But if I upload the excel file to a sharepoint document library and show it in a sharepoint page via the Webpart "document viewer" the data connection is broken and I can not refresh my data.

 

Are there any possibilities to solve this problem?

Thank you all in advance!

0 Replies