Office for Mac Issues

How to Create a Chart from a PivotTable in Excel for Mac

Jason MillerJason Miller Nov 13, 2026 869 views

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.

How to Create a Chart from a PivotTable in Excel for Mac
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the PivotTable

Click any cell inside the PivotTable so Excel recognizes it as the data source.

2
Open the PivotChart menu

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.

3
Configure the PivotChart fields

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 PivotChart directly from the existing PivotTable in Excel for Mac
PivotChart created: The chart is now linked to the PivotTable and will update when the PivotTable structure or filters change.
Free Microsoft Office alternative

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. 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. 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. 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.
Create charts from PivotTable summaries without depending on Excel's Recommended Charts featureOpens and saves Microsoft Excel .xlsx files with PivotTable and chart compatibilityFree, lightweight Office suite for macOS and WindowsFamiliar ribbon interface and chart tools for a smoother transition from Excel for Mac
microsoft office alternative - wps office

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.