Forum Discussion

chhe5's avatar
chhe5
Copper Contributor
Sep 23, 2020

Refresh Excel Chart Sharepoint Page

Hello,

 

I have a sharepoint list that stores the tasks of my team. Now I want to create a burndown chart for this list and embed it on a sharepoint page. The chart webpart does only provide circular and bar chart. So I decided to create a excel sheet with a data connection to the sharepoint list. 

 

In this excel sheet I can create a burndown chart. Now I want to put the chart into a sharepoint page. But I am not able to refresh the data. There comes an error "error by refresh the external data".

 

Is there any solution for this problem? Maybe I can refresh the data by starting a flow every 3 hours or something else?

SharePoint Online

2 Replies

  • Matti Paukkonen's avatar
    Matti Paukkonen
    Iron Contributor
    Sep 23, 2020

    Hi chhe5,

     

    I'm afraid refreshing SharePoint data connection is not possible with Flow. 

     

    SharePoint PnP community have published an Modern Charts example.

    https://github.com/pnp/sp-dev-fx-webparts/tree/master/samples/react-modern-charts

    Is there anything useful for you?

    I can also help trying this out, if you could just provide some example data.

    • chhe5's avatar
      chhe5
      Copper Contributor
      Sep 23, 2020

      Hi Matti Paukkonen 

       

      My company looks away from the installation of community webparts. Unfortunately.

      But when I run the excel sheet local on a network drive there is no problem to refresh the data from the sharepoint list. 

       

      If I upload it to a document library to place the chart by the "document viewer" webpart the refreshing of the data is broken. 

Resources