Can I use SharePoint Online REST API solution to create an interactive chart from a Microsoft List in SharePoint and make the chart a Web Part in my SharePoint site?

Costa, Tatiane 0 Reputation points
2024-06-21T09:13:33.65+00:00

I need to create a chart that connects to an existing list in my SharePoint. I came across a helpful post at https://support.microsoft.com/en-us/office/create-a-chart-by-using-the-chart-web-part-d781ed6d-cbdd-4da9-a5bf-cf346c98db72, but it only explains how to use an Excel template to create a chart. I'm looking for guidance on how to use a Microsoft list instead.

I also attempted to create it using a "Quick Chart" web part, but it did not allow me to select the desired columns from an existing Microsoft List.

Is there a way to create a chart in Microsoft SharePoint using specific columns from an existing Microsoft list using SharePoint Online REST API?

Kind Regards,

Tatiane

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,140 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. RaytheonXie_MSFT 33,176 Reputation points Microsoft Vendor
    2024-06-24T02:21:29.04+00:00

    Hi @Costa, Tatiane，

    You could only use rest api to get the specific columns value. Please refer to following api

    _api/web/lists/getByTitle('Customers')/items?$select=Title

    But there is no such api to create a chart using the value. As a workaround, you could use the following workflow. Please make a reference

    https://techcommunity.microsoft.com/t5/sharepoint/create-a-chart-in-sharepoint-from-a-sharepoint-list/m-p/3254610

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.