How to use quick chart web part in SharePoint Online

This SharePoint Online tutorial explains the Modern SharePoint Quick Chart web part, and also we will learn how to use and configure the Column chart and Pie Chart from the SharePoint list in the Modern SharePoint Quick chart web part. We will check in detail, how to use the quick chart web part SharePoint online.

We can use the Quick chart web part only on the modern SharePoint site. SharePoint modern Quick Chart web part is not available on the Classic SharePoint site.

Modern SharePoint Quick Chart web part

• Microsoft supplies a lot of out-of-box web parts, one of the web parts is the SharePoint Quick Chart web part.
• The quick chart web part is used to display data in a column chart or pie chart on the modern SharePoint site page.
• There exist two ways that we can display data in the Quick Chart web part, either we can directly join the data by editing the quick chart web part else we can get the data from the present SharePoint site list and display it in the modern SharePoint Quick Chart web part.

Read Create SharePoint page template

How to add Quick Chart web part in SharePoint online

Let us see how we can add the Quick chart web part to the modern SharePoint site page,

• Go to the SharePoint site page then select Edit Page at the top right of the SharePoint site page.
• Click + circled icon then add a new Section layout.
• In the search box, enter Quick chart and select the Quick chart web part.

After adding the Quick chart web part, the web part will appear as shown below: In addition, we can add a name to the quick chart web part.

This is how to add the quick chart web part to the modern SharePoint site.

Read SharePoint Navigation – Add parent site navigation to a subsite in SharePoint

Configure Quick Chart web part in Modern SharePoint

Let us see how we can edit and configure the quick chart web part in modern SharePoint.

• Edit the quick chart web part and now we can see three options in the property panel of the quick chart web part, they are:
  • Chart Type
  • Data
  • Layout

Here, you can also see I have Named the quick chart ‘Training Courses’

Now, if we select Chart type option, then we can notice there exist two different types of charts that we can display in the Quick chart web part. They are,

1. Column chart: We can utilize the column chart to display data changes, In the column chart, we can mention the labels on the horizontal axis and Values on the vertical axis under the Layout option.
2. Pie Chart: We can use Pie Chart when we display a smaller amount of items (fewer than 7 items. Pie Chart displays the percentage of the whole. The layout option is not available for Pie Chart.

Now, if we select the Data option, then we can notice there exist two ways that we can get data and display it in the Quick chart web part. They are,

1. Enter data
2. Get data from the list or library on this site

This is how to edit and configure the quick chart web part in the modern SharePoint.

Read Power BI Pie Chart

Data Source as entering data (SharePoint Online Column chart Example)

• When we select an Enter data option, Manually we can add the Value and Data label for our quick chart web part.
• If we choose Enter data as a data source for the quick chart web part, then we can add a maximum of 12 data labels and the value pairs.
• In the Data label text box, we can enter a text, and in the Value text box, we should enter the number else we will get an error message like the below.

Now let us discuss, how to display data in the column chart by entering the Value and Data label in the Quick chart web part.

• Edit the quick chart web part, select the chart classification as a Column chart, and select the data source as entering data as shown below:

• Now, we can manually enter the name of the Value and Data label number for our quick chart web part, we can add a maximum of 12 data labels and the value pairs.
• We can also select the Remove option to delete the Value and Data label pair.
• In this example, I have added four data labels and value pairs as shown below:

• Under layout section, we can mention the labels as Training Courses on the horizontal axis as well Values as Duration in Hours on the vertical axis.
• The maximum number of characters that we can enter is 40.

Select Republish to save your changes. Once Published we can visit the modern SharePoint Quick chart web part displays the data in the Column Chart.

This is how to show data in the Column chart by entering data labels and values pair in the modern SharePoint quick chart web part.

Read Power BI Column Chart

Data source From SharePoint List (SharePoint Online Column chart Example)

We will discuss, how to display data in the column chart by selecting the list or library from the present SharePoint site in the Quick chart web part.

• When we select to get the data from the list or library on the site option, we can choose the list and display the data in the modern SharePoint Quick chart web part.
• If we choose to get the data from the list or library as a data source for the quick chart web part, then we can display a maximum of 50 data in the modern SharePoint quick chart web part.
• In addition, we can also see the sort option to sort the column chart in the modern SharePoint quick chart web part.

In this example, I have created a SharePoint list as ‘Training CourseExample‘ and added two columns Title and Duration In Hours. Title as the Text column and Duration in Hours as Number column.

• Edit the quick chart web part, select chart type as a Column chart, and select the data source to get the data from the list or library on the recent SharePoint site.
• Select the TrainingCoursesExample list as a data source from the dropdown as shown below:

• In addition, we can also see various sort options to sort the column chart in the quick chart web part.
• Available sort options are Ascending data, Descending data, Ascending label, and Descending label.
• By default, the No sort option will be selected.

In the below screenshot, you can see, that I have selected Ascending data under sort order, and it displays the column chart in an ascending data manner in the modern SharePoint quick chart web part.

Select Republish to save your changes. Once Published we can visit the modern SharePoint Quick chart web part that displays the data in the Column Chart.

• We can view the Refresh icon in the quick chart web part, only if we select the data source as get the data from a list or library option.
• We can refresh our column chart by selecting the Refresh Icon( highlighted in red) in the modern SharePoint quick chart web part.

This is how to show data in the column chart by selecting the list or library from the existing SharePoint site and applying sort functionality in the modern SharePoint Quick chart web part.

Read Power BI Funnel Chart

Data Source as entering data (SharePoint Pie chart Example)

We will discuss, how to display data in a pie chart by entering the Value and Data label in the Quick chart web part.

• Edit the quick chart web part, select chart type as a Pie chart and select the data source as entering data as shown below:

• Now, we can manually enter the name of the Value and Data label number for our quick chart web part, we can add up to 12 data labels and the value pairs.
• We can also select the Remove option to delete the Value and Data label pair.
• Layout options are not available for Pie Chart in the modern SharePoint quick chart web part.
• In this example, I have added four data labels and value pairs as shown below:

Select Republish to commit your changes. Once Published we can visit the modern SharePoint Quick chart web part that displays the data in Pie Chart.

This is how to show data in a Pie chart by entering data labels and values paired in the modern SharePoint quick chart web part.

Read Power BI waterfall chart

Data source From SharePoint List (SharePoint Pie chart Example)

We will learn, how to display data in a Pie chart by selecting the list or library from the present SharePoint site in the Quick chart web part.

• When we select to get the data from the list or library on the site option, we can choose the list and display the data in the modern SharePoint Quick chart web part.
• If we choose to get the data from the list or library as a data source for the quick chart web part, then we can display a maximum of 50 data in the modern SharePoint quick chart web part.
• Sort options are not available for Pie Chart in the modern SharePoint quick chart web part.

In this example, I have created a SharePoint list as ‘Training CourseExample‘ and added two columns Title and Duration In Hours. Title as the Text column and Duration in Hours as Number column.

• Edit the quick chart web part, select chart type as a Pie chart, and select the data source to get the data from the list or library on the present SharePoint site.
• Select the TrainingCoursesExample list as a data source from the dropdown as shown below:

Select Republish to save your changes. Once Published we can view the modern SharePoint Quick chart web part that displays the data in a Pie Chart.

• We can view the Refresh icon in the quick chart web part, only if we select the data source as get the data from a list or library option.
• We can refresh our Pie chart by selecting the Refresh Icon( highlighted in red) in the modern SharePoint quick chart web part.

This is how to show data in a Pie chart by selecting the list or library from the existing SharePoint site in the modern SharePoint Quick chart web part.

Read Microsoft Power BI Stacked Column Chart

Modern SharePoint quick chart web part colors

• No, it is not possible to change the color of the Column chart or Pie chart in the quick chart web part of modern SharePoint.
• The Modern SharePoint quick chart web part doesn’t have an option, to change the color of individual data that is displayed in the Column chart as well as Pie Chart.

SharePoint quick chart web part no list available on this site

Let us discuss how we can the no list available in the Quick chart web part in the modern SharePoint,

In the below screenshot, you can see if we cannot get the data from a SharePoint list or library from the present SharePoint site.

But if we check the SharePoint online site contents page, we can see that two lists called EmployeeList and SampleList are presented on the SharePoint site.

The reason, why we see No list available in this SharePoint site is we should have two columns in a SharePoint list One is the Text Column and the other one is the Currency or Number Column.

But you can see only the Text Column is available in the Employee list and the number column is missing and that is the reason we could not select the list from the quick chart web part.

If we add the column as a currency or number in any SharePoint list, then the no list available on this site will not occur while selecting the list from the modern SharePoint Quick web part.

Now you can see, I have added Employee code in the SharePoint Employee list as shown below:

Now if we edit the Quick chart web part, you can able to visit the Employee list.

This is how to fix the no list available on this SharePoint site error in the modern SharePoint quick chart web part.

You may like the following SharePoint web part tutorials:

• SharePoint Button and Call to action Web Part
• SharePoint Image Gallery Web Part
• How to use File viewer web part in SharePoint Online
• SharePoint Highlighted content web part
• SharePoint Quick Links Web Part
• SharePoint Image Web Part
• SharePoint Online Recent Documents Web Part
• SharePoint Online Link Web Part

In this SharePoint tutorial, we learned the what is modern SharePoint Quick Chart web part, how we can add a Quick Chart web part to the SharePoint Online modern site page. And also covered below topics:

• Configure Quick Chart web part in Modern SharePoint
• Data Source as entering data (SharePoint Online Column chart Example)
• Data source From SharePoint List (SharePoint Online Column chart Example)
• Data Source as entering data (SharePoint Pie chart Example)
• Data source From SharePoint List (SharePoint Pie chart Example)
• Modern SharePoint quick chart web part colors
• SharePoint quick chart web part no list available on this site