How to Create a Chart from a PivotTable in Excel for Mac
Question details
The user needs to create a chart from an existing PivotTable in Excel for Mac, but Recommended Charts is not available for the summarized PivotTable data.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- The user has a PivotTable in an Excel workbook on Mac and wants to turn it into a visual chart without copying the data as values.
- Observed behavior
- Excel for Mac may not provide Recommended Charts for an existing PivotTable, and PivotCharts created on Mac may not display the same filter buttons as Excel for Windows.
Open the workbook and confirm the PivotTable is present and selectable. If the PivotTable is based on external data, verify that the connection is active before creating a PivotChart.
Create a PivotChart directly from the existing PivotTable in Excel for Mac
Use this method when Recommended Charts is missing or grayed out for a PivotTable, because it bypasses Excel's recommendation engine and links the chart directly to the PivotTable.
Excel for Mac often does not suggest Recommended Charts for data that has already been summarized in a PivotTable. Inserting a PivotChart manually gives you the same linked visual without relying on recommendations.
A PivotChart created from a PivotTable updates when you change the PivotTable fields or filters, but Excel for Mac may not show every filter button that appears in Excel for Windows.
Click any cell inside the PivotTable so Excel recognizes it as the data source.
Go to the Insert tab on the ribbon and click PivotChart. If you see an Insert Chart dialog, choose the chart type you want and click OK.
Use the PivotChart Fields pane or the PivotChart Design and Format tabs to add, remove, or rearrange the fields and adjust colors, titles, and chart layout.

Create a recommended PivotTable first, then add a PivotChart
Use this alternative when you are starting from raw data and want Excel to suggest a PivotTable before you build a chart.
Use WPS Office Spreadsheet to Create Charts from PivotTables on Mac
If Excel for Mac feels limited when creating charts from PivotTables, WPS Office Spreadsheet offers a free, lightweight, and familiar alternative. It opens and saves Microsoft Excel .xlsx workbooks, supports PivotTable and chart tools, and makes it easy to migrate without losing your data or formatting.
- 1. Download and install WPS Office: Go to the official WPS Office website, download the Mac version, and install WPS Office on your macOS device.
- 2. Open the Excel workbook in WPS Spreadsheet: Launch WPS Office, open your .xlsx workbook, and select the worksheet that contains the PivotTable or source data.
- 3. Create the chart from the PivotTable: Click inside the PivotTable, go to Insert > PivotChart, choose a chart type, and adjust the fields and formatting in the Design tab.

Frequently Asked Questions
Why is Recommended Charts not available for my PivotTable in Excel for Mac?
Excel often disables Recommended Charts after data has already been summarized in a PivotTable. Select the PivotTable and use Insert > PivotChart to create a linked chart manually.
Can I get filter buttons inside a PivotChart on a Mac like in Excel for Windows?
Excel for Mac may not display the same filter-button features as Excel for Windows. You can still control the chart through the PivotChart Fields pane and the Design tab, or open the workbook in WPS Office Spreadsheet for comparable PivotChart options.
How do I change the chart type after creating a PivotChart in Excel for Mac?
Select the PivotChart, go to the PivotChart Design tab, and choose Change Chart Type. Pick a new type from the dialog and click OK to apply it to the linked PivotChart.
Can WPS Office open my Excel for Mac workbook and create a chart from the PivotTable?
Yes. WPS Office Spreadsheet opens Microsoft Excel .xlsx files, preserves PivotTable data, and lets you insert a PivotChart from the Insert tab.
What is the difference between a PivotChart and a regular chart in Excel?
A PivotChart is linked to a PivotTable and updates when you change PivotTable fields or filters. A regular chart uses a static data range and does not automatically respond to PivotTable field changes.




