SharePoint Online quick chart web part (Charting web part)

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.

sharepoint online chart web part
sharepoint online chart web part

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.

modern sharepoint chart web part
modern sharepoint chart web part

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:

charting web part
charting web part

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:

chart web part
chart web part

In the Layout section, it will allow you to provide the name for Horizontal axis and Vertical axis like below:

sharepoint quick chart
sharepoint quick chart

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:

sharepoint online quick chart web part
sharepoint online quick chart web part

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)

sharepoint quick chart from list
sharepoint quick chart from 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.

sharepoint chart web part from list
sharepoint chart web part from list

Then close the web part properties panel and republish the SharePoint page, you can see the SharePoint pie chart will appear like below:

sharepoint online quick chart from list
sharepoint online quick chart from list

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?

sharepoint quick chart no list available on this site
sharepoint quick chart no list available on this site

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.

sharepoint online quick chart no list available on this site
sharepoint online quick chart no list available on this 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:

no list available on this site
no list available on this site

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).

no list available on this site sharepoint
List having currency type column

Now, if you will open the SharePoint Online quick chart web part, you can be able to see the list.

sharepoint online no list available on this site
sharepoint online no list available on this site

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.

view charts in microsoft teams
view charts in microsoft teams

Then in the Add a tab dialog box, select SharePoint and click on Add.

sharepoint quick chart
sharepoint quick chart

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:

sharepoint quick chart from list
sharepoint quick chart from list

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.

sharepoint charting web part
sharepoint charting web part in teams

Once you Save. Then the charts will appear in Microsoft teams like below:

dispay sharepoint charts in microsoft teams
dispay sharepoint charts in microsoft teams

This is how we can display the SharePoint charting web parts in Microsoft teams.

You may like the following SharePoint tutorials:

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
>