Fix SharePoint 2019 Quick Chart Cannot Use List Data
Question details
The user is unable to select a SharePoint list as a data source for the Quick Chart web part.
- Product
- SharePoint Server 2019
- Device & OS
- not provided
- Scenario
- Trying to create a Quick Chart on a SharePoint Server 2019 page using an existing list that contains supported column types.
- Observed behavior
- The option to use data from a SharePoint list is completely missing in the Quick Chart web part configuration pane.
Ensure you have site editing permissions in SharePoint Server 2019 and verify that your target SharePoint list is located on the exact same site as your Quick Chart web part.
Consult the Official Microsoft SharePoint Server Forum
Since this is a specific limitation related to the on-premises SharePoint Server 2019 environment rather than SharePoint Online, reaching out to specialized server administrators is the recommended path for official clarification.
SharePoint Server 2019 has a different feature set compared to Microsoft 365's SharePoint Online. Some out-of-the-box web parts, like Quick Chart, may lack newer functionalities such as pulling data directly from lists.
Open your web browser and navigate to the official Microsoft Q&A platform.
Use the search bar and select the 'SharePoint Server' tag to filter discussions specifically related to on-premises deployments.
Create a new thread detailing your specific scenario, mentioning that the Quick Chart web part fails to offer the list data option despite having supported text and number column types.
Wait for verified Microsoft experts or server administrators to provide information on server-specific patches or confirm if this is a hard limitation for the 2019 edition.
Verify Supported Column Types and Use Workarounds
Ensure the list data structure strictly meets Quick Chart requirements, or consider using alternative charting methods like embedding Excel charts.
Create and Share Beautiful Charts with WPS Office
If you are facing web part limitations in SharePoint, you can easily export your data and create highly customizable charts offline. WPS Office is a free, lightweight, and complete office suite that offers seamless compatibility with Microsoft Excel formats for all your data visualization needs.
- 1. Export Data: Export your SharePoint list data as an Excel (.xlsx) file to your local computer.
- 2. Open with WPS Spreadsheet: Launch WPS Office and open the downloaded spreadsheet file.
- 3. Insert Chart: Select your data range, navigate to the Insert tab, and choose your preferred Chart type to instantly visualize the data.
Frequently Asked Questions
Why does Quick Chart work in SharePoint Online but not SharePoint 2019?
SharePoint Online receives continuous feature updates from Microsoft, including enhanced functionalities for web parts. SharePoint Server 2019 has a fixed feature set based on its release date, meaning some web parts like Quick Chart have more limited capabilities compared to their cloud counterparts.
What column types are required for a SharePoint list to work with a Quick Chart?
To generate a Quick Chart, your SharePoint list must contain at least one text or choice column to serve as the data labels (X-axis) and at least one number or currency column to provide the data values (Y-axis).
Can I embed an Excel chart into a SharePoint 2019 page instead?
Yes. You can export your SharePoint list data to an Excel workbook, create your desired chart within the spreadsheet, upload the file to your SharePoint Document Library, and then use the File Viewer web part to display the chart directly on your site page.
