S
SallyC
In Excel 2003, when you create a Pivot Chart with a field in the Page Fields
area, you can choose an item to filter by, which is then displayed on the
chart so that when you print, you know which item has been chosen. However,
with the 'advances' made in Excel 2007, the Page Field is now the Report
Filter in the Pivot Table Field List so when you print the chart, nowhere
does it say what the item is! Surely this is a backward step - unless I'm
missing an option somewhere?
area, you can choose an item to filter by, which is then displayed on the
chart so that when you print, you know which item has been chosen. However,
with the 'advances' made in Excel 2007, the Page Field is now the Report
Filter in the Pivot Table Field List so when you print the chart, nowhere
does it say what the item is! Surely this is a backward step - unless I'm
missing an option somewhere?