Others

Fix a SharePoint List Missing from the Quick Chart Web Part

Bushra ParveenBushra Parveen 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.

Why a SharePoint List Does Not Appear in 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.
Before you start

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.

Solution 1Recommended

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.

1
Create a numeric count

Open the list, select Add column > Number, and name the column Count. Set its default value to 1, then save it.

2
Populate existing items

Open existing list items or use Edit in grid view to enter 1 in the Count column for each item you want to include.

3
Provide text categories

Use the Title column or add a Single line of text column for categories. Enter the corresponding Choice value as text for each item.

4
Configure Quick Chart

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.

Add a Number column and use a text column for categories
Keep category values aligned: If the original Choice value changes, update the text category too. Check the chart aggregation settings to confirm that Count values are summarized as intended.
Free Microsoft Office alternative

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.

Create charts from exported list data in a familiar spreadsheet interfaceOpen and edit Microsoft Excel XLSX and XLS filesUse a free, lightweight Office alternativeMove existing spreadsheet work into WPS with familiar editing tools
microsoft office alternative - wps office

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.