Quick Charts Using SharePoint List Data

In Modern SharePoint sites, a “Quick Chart” web part now has the ability to pull data from a SharePoint list.

quickchart_icon Add the “Quick Chart” web part from the edit menu.

*My preference is using the One-third width section layouts.

pencil_edit Select the pencil icon to edit the “Quick Chart”.

There are currently 2 types of charts currently available the Column Chart and the Pie Chart.

columnchart The column chart can show data changes over time or comparisons. Categories are shown along horizontal axis and values along the vertical access.
piechart The pie chart is used to show percentages of a whole and recommended with fewer than seven categories.

Under the Data section select – Get data from a SharePoint list on this site

getdatafromsplist.PNG

quickchartsdata Select a Number column that has the data to display.

Then select a Text type column to display the labels.

Configure the Sort order if necessary.

Now your data can be read in a dashboard on any Modern Page.

quickcharts

5 thoughts on “Quick Charts Using SharePoint List Data

  1. CHRIS MCCLAIN February 18, 2020 / 2:06 pm

    Only 50 items will be displayed the list and there are limitations to columns that can be selected.

    Liked by 1 person

  2. cpu August 4, 2020 / 1:44 am

    In SharePoint 2019 the option of List is removed šŸ˜¦

    Liked by 1 person

    • My SharePoint Questions August 4, 2020 / 8:37 am

      Hi cpu, I am just assuming that this is due to the patch that your version of SharePoint is currently running on. As soon as your SharePoint Admin runs a cumulative update on your servers, I would think you would see the option. SharePoint Online should be a little ahead of SharePoint on-premises.

      Like

Leave a comment