Others

How to Create a SharePoint Chart from an Existing Microsoft List

WPS Content Manager Oct 1, 2026 868 views

Question details

The user wants to create an interactive SharePoint dashboard or chart using selected columns from an existing Microsoft List.

How to Create a SharePoint Chart from an Existing Microsoft List

Product: SharePoint, Microsoft Lists
Device & OS: not provided
Scenario: Setting up a data visualization on a SharePoint page using an existing list as the data source.
Observed behavior: The native Quick Chart web part fails to detect or load lists that are stored in the user's 'My Lists' directory instead of the specific SharePoint site.

Before you start

Verify the storage location of your Microsoft List to ensure it is hosted on the active SharePoint site rather than in your personal 'My Lists' folder.

Solution 1Recommended

Migrate the List to the SharePoint Site

Since the Quick Chart web part cannot read data from 'My Lists', recreating or moving the list to the target SharePoint site resolves the data detection issue.

The SharePoint Quick Chart web part is designed to look for list data exclusively within the site where the web part is hosted. Lists created in the standalone Microsoft Lists app under 'My Lists' are functionally isolated.

Open the SharePoint Site

Navigate to the SharePoint site where you intend to build the chart and click on 'New', then select 'List'.

Create from an Existing List

Choose the 'From existing list' option and locate the list currently saved in your 'My Lists' directory to duplicate its structure and data to the site.

Add the Quick Chart Web Part

Edit your SharePoint page, click the '+' icon to add a new web part, and search for 'Quick Chart'.

Configure the Chart

Click the 'Edit web part' pencil icon, select 'Get data from a SharePoint list on this site', and choose your newly migrated list to build the visualization.

List Synchronization: Creating a list from an existing list copies the structure. You may need to export and import the data to Excel if the list contains a large number of existing records.

Solution 2

Use Power BI for Advanced List Visualization

If you need flexible reporting across multiple lists or environments, Power BI can extract list data via API and embed it directly into SharePoint.

Free Microsoft Office alternative

Analyze and Chart List Data Easily with WPS Office

While SharePoint handles enterprise web portals, WPS Office offers a free, lightweight, and highly compatible alternative for analyzing exported Microsoft List data offline. Easily convert your list exports into professional charts and dashboards without dealing with complex web parts.

1. Export the Microsoft List: Open your Microsoft List, click the 'Export' dropdown in the top menu, and select 'Export to Excel' or 'Export to CSV'.
2. Open with WPS Spreadsheet: Launch WPS Office, open the downloaded file, and review your dataset.
3. Generate Custom Charts: Highlight the columns you want to visualize, navigate to the 'Insert' tab, and select from a wide variety of chart types to instantly build your reporting dashboard.

Seamless compatibility with Microsoft Excel (.xlsx) and CSV files exported from Microsoft Lists.Free and lightweight suite providing advanced spreadsheet charting tools without subscription fees.Familiar user interface that makes transitioning from Microsoft Office completely effortless.Rich visualization options to turn raw list data into presentation-ready graphs instantly.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the Quick Chart web part say no lists are available on this site?

The Quick Chart web part strictly scans the local SharePoint site where it is placed. If your list was created in your personal 'My Lists' app or on a different site collection, the web part will not be able to detect or load it.

Can I use REST API or Microsoft Graph to build custom SharePoint charts?

Yes, for developers needing flexible reporting, you can write custom code using the SharePoint REST API or Microsoft Graph API to fetch data from any list location and render it using a custom web part framework (SPFx).

How can I automate data updates for my list charts?

You can utilize Microsoft Power Automate to create workflows that trigger whenever a new item is added or modified in your Microsoft List, ensuring your connected Power BI dashboards or external charts remain completely up to date.

Office Quick Solutions