Fix a SharePoint List Missing from 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
- SharePoint Quick Chart web part
- Device & OS
- not provided
- Scenario
- The user wants to chart list data that includes a Choice column, even though the list is usable in Power Apps.
- Observed behavior
- The list may not appear as a Quick Chart data source, or its Choice column may not be available for selection.
Open the SharePoint list and check the column types under Settings > List settings. Confirm that you can edit the list and the page containing the Quick Chart web part.
Add a Number column and use a text column for categories
Use supported numeric and text fields to make the list available to Quick Chart and chart category counts.
Quick Chart may not offer Choice, Calculated, or Lookup columns as chart fields. Adding a Number column can make the list available, but it does not make an unsupported Choice column selectable.
Open the list, select Add column > Number, and name the column Count. Set its default value to 1, then save it.
Open existing list items or use Edit in grid view to enter 1 in the Count column for each item you want to include.
Use the Title column or add a Single line of text column for categories. Enter the corresponding Choice value as text for each item.
Edit the SharePoint page, open the Quick Chart web part settings, and choose the option to get data from a SharePoint list on the site. Select the list, the text category field, and Count as the numeric value where those options are available.

Use Power BI for more flexible SharePoint list charts
Use Power BI when Quick Chart does not expose the fields or chart options you need.
Create Spreadsheet Charts with WPS Office
For a separate spreadsheet chart, export your SharePoint list and open it in WPS Spreadsheet. WPS Office is a free, lightweight alternative with a familiar interface and compatible formats that make moving spreadsheet work easier. It does not fix the SharePoint Quick Chart web part.

Frequently Asked Questions
Why does my list work in Power Apps but not appear in Quick Chart?
Power Apps and Quick Chart support data differently. Quick Chart may need a supported Number column before it offers the list as a data source. Check the list's column types in Settings > List settings.
Can I select a Choice column as a Quick Chart category?
A Choice column may not be available in Quick Chart. Use the Title column or a Single line of text column containing the category values, and keep those values aligned with the original Choice field.
Will a default Count value fill existing list items?
Do not assume it will. Check existing items and use Edit in grid view to enter 1 in the Count column where needed.
What can I use if Quick Chart cannot show the data I need?
Connect to the SharePoint Online list through Home > Get data in Power BI Desktop, build a report, and publish it. You can then add the report to a SharePoint page with the Power BI web part, subject to access and licensing requirements.




