Pivot Chart - Show Selected Filters

Hi,

My employer has finally upgraded from Excel 2003 to 2010 and I'm currently playing catchup to learn what's changed!

I used to have a number of pivot charts where users had the option to select certain filters from the report filter and where those fields show at the top of the chart, you could see which item had been selected (So if one of those filters was "Colour" you could see that the user had selected "Red" and therefore that the chart related only to Red items. When I try to replicate in 2010, everything works, but at the top, you can no longer see which items have been filtered.

It used to be really hand as we could use the same chart for various summary views for different people or print them out, and people knew exactly what it covered.

Does anyone know if there's a way to make that visible in Excel 2010?

Thanks!

Hi,

Can you please post template which you are trying to convert into Excel 2010?