Good morning,
We seem to have lost some functionality in Excel 2007 pivot charts. Can anyone confirm this? I hope I'm mistaken and that there are some parameters or options I haven't found yet, but I fear not.
In earlier Excel a pivot chart retained its own row and column labels and drop down filters independently of the underlying pivot table. This meant that you could drag and drop these around on the chart and filter in the usual way. In 2007 we sem to have lost this functionality, and the only way to interpret or modify a chart is to go back to view/change the underlying Pivot Table.
I hope I'm wrong. Can anyone comment please?
See attached file containing pictures of the tables and charts.
Bookmarks