View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Show current Report Filtered in Pivot Chart

Excel 2007
This will show the selected items
of the Report Filter (Page selection)
in the Chart Title header.
Some VBA required.
http://www.mediafire.com/file/dndt1kqjyl4/01_21_09.xlsm