Pivot charts filter field in 2007

[Raja]

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

 

[Ed Ferrero]

Hi Raja,

A workaround...

Add a text box to the chart. With the the text box selected, enter a formula
in the formula bar, that references the cell containing your pivot table
filter - like =Sheet1!$B$2

Ed Ferrero
www.edferrero.com

 

[Raja]

Dear Ed

Thank you for your response. I tried that. I created a Text box and typed
the following formula:

=Sheet1!$B$2

When I click on the text box I can see teh function on the formula bar but
Nothing seems to be displaying on eth text box.

I tried to see if there are any settings and even tried ot resize the text
box.

Do you know where I might be going wrong?

Kindest Regards

Rajeev Rawat

 

[Ed Ferrero]

Hi Raja,

Is there anything in cell B2 ? Try typing something in cell B2, the textx
box should show the contents of cell B2.

Replace $B$2 with the cell address that contains your pivot table filter
value.

Ed Ferrero