SharePoint Online: How to Create Chart from List Data using Quick Chart Web Part?

Requirement: Create a Chart from List data in SharePoint Online.

Charts can help you better visualize data and make informed decisions. In this blog post, we will show you how to create a chart from list data using the Quick Chart web part in SharePoint Online. We will walk you through the steps of creating a custom chart and then adding it to a SharePoint page.

Here is my SharePoint Online list data:

quick chart web part in sharepoint online

How to Create Quick Chart from List Data in SharePoint Online?

We can use the Quick chart web part in Modern SharePoint Online sites to build a bar chart or pie chart from list data. Here is how to use the Quick chart web part to create a chart from the list:

  1. In your Modern SharePoint Online site, create a new page or edit an existing page.
  2. Click on the “+” icon to add a Web Part. In the web parts popup, search “Quick chart”, and you’ll find the Quick chart web Part as the below
    screen. sharepoint online chart from list
  3. Click on the “Quick Chart” web part to add it to the page. sharepoint online create chart from list
  4. Once added, Click on the pencil icon in the quick chart web part area. This opens web part properties in edit mode. 
  5. Select chart type: either “Column chart” or “Pie Chart”. Specify the option to get the data from the SharePoint list.
  6.  Select the SharePoint list where the chart data resides. Specify the columns for labels and data. optionally set the sort order.sharepoint online quick chart from list

That’s all. This builds a chart in SharePoint Online with a few clicks!

In summary, creating a chart from a SharePoint Online list is a simple and effective way to visualize data and make informed decisions. By following the steps outlined in this guide, you can create a quick chart from your SharePoint Online list in just a few clicks.

Salaudeen Rajack

Salaudeen Rajack - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the real-world articles!

2 thoughts on “SharePoint Online: How to Create Chart from List Data using Quick Chart Web Part?

  • Hi Salaudeen Rajack ,As jhonny says, with the quick chart method, you cannot group, or put other types of charts, and there are only expensive alternatives. There would be another way to create the graphics ourselves and connect them to the sharepoint lists. Thanks in advance

    Reply
  • Unfortunately the Quick chart is quite limited in its features – namely, it doesn’t support aggregations (sum etc). Or filtering. Here is a commercial alternative: https://appsource.microsoft.com/en-gb/product/office/WA200001942?tab=Overview

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *