SharePoint Document Issues

Fix Missing SharePoint Lists in the Quick Chart Web Part

Kushani NimanthikaKushani Nimanthika Nov 22, 2026 868 views

Question details

The user needs to make a SharePoint list available as a data source for the Quick Chart web part.

Fix Missing SharePoint Lists in the Quick Chart Web Part
Product
Microsoft SharePoint Quick Chart web part
Device & OS
not provided
Scenario
The user wants to create a chart from a SharePoint list that does not contain numeric columns.
Observed behavior
The desired list does not appear in the Quick Chart web part; only Workflow Tasks is available.
Before you start

Open the target list and check that you can view its items. Review its columns to see whether it contains numeric data that the chart can use.

Solution 1Recommended

Check the SharePoint list and add numeric data

Use this approach to check whether the list has the numeric data needed by Quick Chart.

Quick Chart requires a compatible list with numeric data. Adding a numeric column may help, but it does not guarantee that every list will appear or that Quick Chart will automatically count and aggregate nonnumeric entries.

1
Check access to the list

Open the SharePoint site, select the target list from Site contents, and confirm that you can view its items. If you cannot, ask the site owner to check your access.

2
Review the list columns

In the list, select the settings gear, then List settings, and review the column types. Look for a Number column containing values you want to chart.

3
Add a numeric column if needed

In the list, select Add column, choose Number, name the column, and save it. Enter meaningful numeric values for the items you want to chart.

4
Recheck the Quick Chart source

Open the SharePoint page, select Edit, and use the Quick Chart web part's edit button to check the list data source options again. If the list appears, select it and configure the chart using the numeric data.

Check the SharePoint list and add numeric data
Automatic counts may not be available: If your goal is to count items by a text category, adding a Number column alone does not create those counts. You may need to prepare a numeric summary separately or request an enhancement.
Free Microsoft Office alternative

Create charts from list data with WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface and support for Microsoft Office formats, making it easy to move spreadsheet data into WPS. Use WPS Spreadsheets to chart prepared list data; it does not fix missing sources in the SharePoint Quick Chart web part.

Create charts from numeric list data or prepared summaries.Open and edit Microsoft Excel XLSX and XLS files for easier migration.Work in a familiar spreadsheet interface.Use a free, lightweight alternative to Microsoft Office.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Quick Chart show Workflow Tasks but not my list?

The target list may not meet Quick Chart's data requirements or you may not have access to it. Open the list from Site contents, confirm that you can view it, and check for a numeric column in List settings.

Can Quick Chart automatically count items in a text column?

Do not assume that Quick Chart will automatically aggregate text entries. If you need counts by category, prepare a numeric summary separately or submit a feature request through the Microsoft Feedback portal.

How do I add a numeric column to a SharePoint list?

Open the list, select Add column, choose Number, and save the column. Enter the numeric values you want to use, then recheck the data source options in the Quick Chart web part.

Will WPS Office make my list appear in SharePoint Quick Chart?

No. WPS Spreadsheets can create charts from prepared spreadsheet data, but it does not change which lists are available to the SharePoint Quick Chart web part.