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:
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:
- In your Modern SharePoint Online site, create a new page or edit an existing page.
- 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.
- Click on the “Quick Chart” web part to add it to the page.
- Once added, Click on the pencil icon in the quick chart web part area. This opens web part properties in edit mode.
- Select chart type: either “Column chart” or “Pie Chart”. Specify the option to get the data from the SharePoint list.
- Select the SharePoint list where the chart data resides. Specify the columns for labels and data. optionally set the sort order.
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.
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
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