unlink pivot chart axis fields from pivot table rows fields

Question

Is it possible to unlink a pivot chart axis selection from the pivot table rows? Whenever I remove one of the pivot chart axis fields to display the chart correctly, excel also removes the field from the pivot table rows selection which is not what I need.

The images below may help show what I mean - if I remove field "Division" from the pivot chart axis selection, the field is also removed from the pivot table rows selection. I have a sample spreadsheet which can do this - link is here.

Thanks for any suggestions.

Answer 1

A pivot chart is invariably linked to the underlying pivot table. Removing fields from the Rows field well will remove them in both the chart and the table. That's just how it works.

Edit after viewing sample file:

The sample file has just one pivot cache, but it has several pivot tables. The two pivot tables for the two pivot charts on the dashboard live on the "Pivots" worksheet and are not connected to the pivot table on the dashboard.

So, if you want to create a pivot chart and a pivot table with different fields, you need a separate pivot table for the chart. You may want to create the pivot chart first, on a helper sheet, then move the chart to the dashboard and leave the underlying pivot table on the helper sheet.

Then add another pivot table to the dashboard sheet and use columns that are independent from the pivot chart.