pivot table and charts
 

When creating a pivot chart from a pivot table in excel 2003 the filter on
the entire report (possibly called the page filter in 2003) shows in the
chart so you could manipulate the chart directly and not have to go back to
the pivot table to view another section of data. I can not find this same
option in 2007. This is only an issue because while I am saving the file in
the 2003 format that dropdown is not available on anyone else's computer when
they view the file I created in 2007.

Thanks,