How to Create a Pie Chart from Microsoft Lists Data in Excel
Question details
The user wants to visualize Microsoft Lists data to summarize completed and not started tasks using a pie chart.
- Product
- Microsoft Lists / Excel
- Device & OS
- not provided
- Scenario
- Visualizing task status data tracked within Microsoft Lists.
- Observed behavior
- Microsoft Lists lacks a built-in pie chart generation feature, requiring a workaround to visualize the data.
Ensure your Microsoft Lists data contains a clear categorical column, such as 'Status', and that you have a spreadsheet application like Excel or WPS Spreadsheet installed to process the exported data.
Export List Data to Excel and Create a PivotChart
Since Microsoft Lists does not support native pie charts, exporting the list data to a spreadsheet and generating a PivotChart is the most effective way to visualize task statuses.
This method allows you to group task statuses dynamically using a PivotTable. By placing your status categories into rows and counting the task instances, you can generate a visual Pie Chart that updates if you refresh the exported data.
Open your Microsoft List in the browser, click the 'Export' button on the top command bar, and select 'Export to Excel'.
Open the downloaded Excel file, select your entire data range, navigate to the 'Insert' tab on the ribbon, and click 'PivotTable'.
In the PivotTable Fields pane on the right, drag the 'Status' field into the 'Rows' area. Then, drag a unique task identifier (such as the task name or ID) into the 'Values' area to count the number of tasks per status.
With any cell inside the PivotTable selected, go to the 'PivotTable Analyze' tab, click 'PivotChart', choose the 'Pie' chart format, and click 'OK'.
Use WPS Spreadsheet to Create Beautiful Pie Charts
WPS Spreadsheet provides a seamless and completely free way to open your exported Microsoft Lists data, build PivotTables, and generate stunning Pie Charts without requiring a paid Microsoft Office subscription.
- 1. Open Exported Data: Launch WPS Spreadsheet and open the .xlsx or .csv file you exported from Microsoft Lists.
- 2. Create a PivotTable: Highlight your data, navigate to the 'Insert' tab, and click 'PivotTable'. Group your task statuses into rows and values.
- 3. Insert a Pie Chart: Select the generated PivotTable, go to the 'Insert' tab, click 'Chart', and choose the 'Pie' format to visualize your tasks instantly.
Frequently Asked Questions
Can I embed the created pie chart back into Microsoft Lists?
No, you cannot insert charts directly back into a Microsoft List. However, you can display the generated charts on a SharePoint site by embedding the Excel workbook or using the SharePoint Quick Chart web part.
Why isn't there a built-in pie chart feature in Microsoft Lists?
Microsoft Lists is primarily designed for structured data entry and tracking. Microsoft delegates advanced data visualization, reporting, and charting to integrations with Excel and Power BI.
Do I need a paid Excel subscription to create this pie chart?
No, you can simply export the list data as a standard .csv or .xlsx file and use a free spreadsheet application like WPS Spreadsheet to create the PivotTable and pie chart.
