Are you looking for a quick SharePoint charting web part? In this SharePoint tutorial, I am going to explain everything about SharePoint Online quick chart web part.
Here, we will see in detail how to create column chart or pie chart in SharePoint Online modern sites. How we can create SharePoint Online quick chart from list.
SharePoint online quick chart web part
Let us first understand the charting web part that we can use only in SharePoint Online modern sites. The sharepoint quick chart web part will not be available in classic SharePoint sites.
Microsoft provides a modern sharepoint chart web part to display charts on a SharePoint page quickly. The charting web part is known as the quick chart web part.
The quick chart web part allows us to display a simple column chart and pie chart. You can enter the data while configuring the chart web part or even it allows us to get data from a SharePoint list presented on the current site.
Let us see how to add chart web part in SharePoint and a demo of sharepoint quick chart from list or sharepoint chart web part from list.
Add Quick Chart Web Part
Open the SharePoint Online modern site, create a page where you want to add the chart web part.
Then open the site page and click on Edit. You can optionally add a section with one column layout or a two-column layout where you can add the web part.
Then click on the + icon to add any web part to the page. Search for quick and you can see the Quick chart web part. Select the web part to add the web part to the SharePoint site page.
Once you add the web part to the page, the web part will appear like below: Here you can provide a name for the chart in (Name your chart).
Then click on the Edit icon of the charting web part and it will open the properties panel where we can configure the chart web part in SharePoint Online.
Types of Charts
There are two types of chart that SharePoint quick chart web part allows us to display.
- Column chart
- Pie chart
Column chart: You can use the column chart to show data changes compare to other items. Here in the horizontal axis, you can see the categories and the vertical axis will have the values.
Pie chart: The pie chart will display the percentage of a whole. If you have fewer items (less than 7 recommended) then you can use the pie chart.
Here, we will see examples of both column chart and pie chart.
The SharePoint Online chart web part provides two options for data.
- Enter data
- Get data from a SharePoint list on this site
By manually entering data, we will see here how to do a column chart. And by getting data from a SharePoint list, we will make a pie chart.
Enter data (SharePoint Column chart example)
Now, let us see a SharePoint column chart example by entering data manually.
Once your edit the quick chart web part as explained above, you can see the properties panel.
There first select Chart type as Column chart and Data, Enter data option like below:
Once you select Enter data, the chart web part allows you to enter the data label and value for your chart. You can enter up to 12 data label and value pairs. I have added like below:
In the Layout section, it will allow you to provide the name for Horizontal axis and Vertical axis like below:
After this close the sharepoint quick chart web part properties panel and Publish the page, you can see the SharePoint column chart will appear like below:
This is how we can add a column chart in SharePoint Online by using the quick chart web part.
Read How to create a private channel in Microsoft Teams
SharePoint chart web part from list (Pie chart)
Now, we will see an example of a sharepoint chart web part from list. We will create a pie chart from SharePoint list data using the sharepoint online quick chart web part.
Follow the above step and add a quick chart web part to the SharePoint Online modern site page. The edit the web part to open the quick chart properties panel.
Then in the Chart Type select Pie chart.
In Data section, select Get data from a SharePoint list on this site.
Then it will populate all the lists that are presented in the current SharePoint site. (The list should have a text and a number or currency type column, else the list will not appear in the dropdown list)
Here the SharePoint Online list looks like below, it has a Training course name as a text type column and Course Price as a currency type column.
Then close the web part properties panel and republish the SharePoint page, you can see the SharePoint pie chart will appear like below:
This is how we can display SharePoint Online quick chart from list.
SharePoint online quick chart no list available on this site
Want to know why you are getting sharepoint quick chart no list available on this site error message like below?
From the error message No list available on this site, it looks as if there is no list presented on the SharePoint site.
But if you look at the SharePoint site contents page, you can see there are two lists are presented in the site.
Then why the sharepoint online quick chart no list available on this site error?
Ideally, there should be a list that will have at least two columns with the below data types:
- Text column
- Number/Currency column
If you look at both the list, then bother have an only a single line of text column, no number or currency type column presented like below:
If you will add a column of type number or currency to any list then the error no list available on this site will not appear and the list will appear to get data for the chart web part.
You can see I have added the Price column (Currency).
Now, if you will open the SharePoint Online quick chart web part, you can be able to see the list.
This is how we can fix SharePoint quick chart no list available on this site error.
Display SharePoint charts in Microsoft teams
Now, let us see how to display SharePoint charts in Microsoft teams. We will see here how we can display those charting web parts in Microsoft teams.
Open Microsoft teams, then click on Teams -> Select a Team where you want to display the charts. Then click on the + icon to add a tab.
Then in the Add a tab dialog box, select SharePoint and click on Add.
Then in the next dialog box, it will show the pages from the teams (SharePoint site). If the SharePoint site page (that contains our charts) is presented in the team, select the page from the pages section.
Else select Add page or list from any SharePoint site link like below:
Then it will ask you to enter the link for the SharePoint page or list. Here we have the chart web parts on a site page. Enter the SharePoint page link or URL like below and click on Save.
Once you Save. Then the charts will appear in Microsoft teams like below:
This is how we can display the SharePoint charting web parts in Microsoft teams.
You may like the following SharePoint tutorials:
- Enable Chart Web Part in SharePoint 2013/2016/Online
- SharePoint Online storage limits (Detailed Guide)
- SharePoint Online regional settings
- How to enable script editor web part in SharePoint Online Office 365
- Embed Power BI report in SharePoint Online
- PowerApps charts (Column, Line and Pie Chart)
- SharePoint Online Gantt Chart View for Task List
- SharePoint online quick links web part – How to use
- SharePoint Online Highlighted Content Web Part
- Create SharePoint Online Modern Page
In this SharePoint tutorial, we learned charting web part in SharePoint and how to use the SharePoint Online quick chart web part:
- How to add and configure quick chart web part
- Display column chart and pie chart using SharePoint quick chart web part
- sharepoint online quick chart from list
- How to fix the error, sharepoint online quick chart no list available on this site.
- How to display SharePoint charts in Microsoft teams
I am Bijay a Microsoft MVP (8 times – My MVP Profile) in SharePoint and have more than 15 years of expertise in SharePoint Online Office 365, SharePoint subscription edition, and SharePoint 2019/2016/2013. Currently working in my own venture TSInfo Technologies a SharePoint development, consulting, and training company. I also run the popular SharePoint website EnjoySharePoint.com
Its really helpful. Was exactly looking for this. Explained very well. Thanks