I remember in Excel 2003 when you created a Pivot Charts you could drag and
drop the fields to the various areas such as Page area, Series and so on.

In 2007 I know that I can easily drag and drop the fields in the Pivot Tabel
filed list.

One thing that is really bothering me is that once I put a field e.g. Region
in the report Filter area and filtered the region such as North. The data
automatically changes accordingly but there is no way of finding what Region
the data is being displayed for. If I had to print this chart on its own it
would be very difficult to figure this out.

This problem was never there in Excel 2003 as you could instantly see which
Region you have filtered.

Can someone please tell me how I can see the name of the chosen region on
the top of the chart? I don't want to type it manually every time as i might
be changing that frequently!!

Kindest Regards
Rajeev Rawat