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.
quick chart web part in sharepoint online
quick chart web part in SharePoint online

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.

add quick chart web part in sharepoint online
add quick chart web part in SharePoint online

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.

quick chart web part in the SharePoint online
quick chart web part in the SharePoint online
  • 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.
chart types in quick chart web part SharePoint online
chart types in quick chart web part SharePoint online

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
quick chart web part data in SharePoint online
quick chart web part data in SharePoint online

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

See also  tabulator js tutorial | tabulator js example

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.
quick chart web part data value in SharePoint online
quick chart web part data value in SharePoint online

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:
SharePoint online Column chart example
SharePoint online Column chart example
  • 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:
SharePoint online Column chart example in the quick chart web part
SharePoint online Column chart example in the quick chart web part
  • 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.
quick chart web part layouts in the SharePoint online
quick chart web part layouts in the SharePoint online

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.

Modern SharePoint Column chart example
Modern SharePoint Online Column chart example

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.

Column chart example in quick chart web part
SharePoint online quick chart from the list
  • 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:
sharepoint online quick chart from list
SharePoint online quick chart from the list
  • 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.
See also  Display modal pop up in SharePoint Online/2013/2016

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.

quick chart web part sort in the SharePoint online
quick chart web part sort in the SharePoint online

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.
Modern SharePoint Column chart list example
SharePoint online quick chart from the list

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:
SharePoint online pie chart example in quick chart web part
SharePoint online pie chart example in the quick chart web part
  • 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:
SharePoint online pie chart example in the quick chart web part
SharePoint online pie chart example in the quick chart web part

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.

quick chart web part pie chart in the SharePoint online
quick chart web part pie chart in the SharePoint online

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.

pie chart example in the quick chart web part
pie chart example in the quick chart web part
  • 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:
SharePoint modern pie chart example in quick chart web part
SharePoint modern pie chart example in the quick chart web part

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.
SharePoint online pie chart example
SharePoint online pie chart example

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.

See also  Create and Manage Task List in SharePoint

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.

sharepoint quick chart not showing list
SharePoint quick chart not showing a list

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.

quick chart web part no list available on this site
quick chart web part no list available on this 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.

quick chart web part no list available on this modern sharepoint site
quick chart web part no list available on this modern SharePoint site

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:

sharepoint quick chart not showing list example
SharePoint quick chart not showing list example

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

quick chart web part no list available on this modern sharepoint site example
quick chart web part no list available on this modern SharePoint site example

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:

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
>