Is it possible to create a PivotChart off an existing PivotTable, but in the PivotChart, not use all the fields.
Reason being, in the PivotTable I am using a specific field in the Data area to base my sort order for my Row item field, but I do not necessarily want that field in the data area to show in the PivotChart.
Thanks
You would need to create another pivot table using the same pivot cache.
the chart and table are inter-linked with 1 reflecting the changes in the other.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks