Fix Missing SharePoint Lists in the Quick Chart Web Part
Question details
The user needs to make a SharePoint list available as a data source for 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.
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.
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.
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.
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.
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.
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.

Request automatic aggregation through Microsoft feedback
Use feedback if Quick Chart does not support the list or aggregation behavior you need.
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.

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.




