Only need to PivotChart to show one or two data fields (not all of them)

S

sarahmarsden

I have a PivotTable which has 7 columns of data of which only 2 at the
most would be relevant on my PivotChart. The PivotTable has averages,
sums, counts all which don't graph well together.

How can I choose only the data fields I want to display but keep the
PivotChart attached to the PivotTable so it still automatically
updates?

Thx, Sarah
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link PivotChart to PivotTable, whilst hiding fields 0
PivotTable/Chart - Statistics (Excel 2007) 1
PivotTable - feature like "value range" or "slices" available on regular fields? 0
Data count on pivotchart columns? 0
Excel 2010: How to display PivotChart Report Filter Lables on the graph 2
Change name of labels in a PivotChart 4
Multiple chart series for PivotChart 0
Exporting PivotCharts and PivotTables from a workbook without"breaking" them 0

Top