Implement and show pivot chart filtering in excel 2007 as in 2003

T

Tore

I have a report (excel workbook) with a number of pivot tables and pivot
charts that is distributed to customers. Some of these customers are not very
familiar with excel and pivot tables.

In excel 2007 pivot charts I would like to show the filtering based on
page-field in the source pivot table. This is readily available in excel
2003. How can the excel 2003 pivot chart filtering be shown in excel 2007?

I know about the pivot chart filtering pane. This is not what I want to
present to customers.

If I print the pivot chart from excel 2007, I would like the filtering to be
shown in the chart. How can this be done?

Regards
 

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

Doughnut Chart linked with the slicer in the pivot table 0
Change report firlds in pivot tables and charts with one selection 0
Pivot Table - charts - default ? 0
Excel does not accept text format! 0
Using VBA to create charts 1
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 13
Please help! Cannot open pivotTable source file.... 2
create a pivot table and chart from a named range 1

Top