Show the item selected from Report Filter in a Pivot Chart
 

Hi

I use Excel 2007. I have a pivot table set up with a Report Filter showing
all the months of the year.

Is it possible if I select the items from the Report Filter, for example
"Jan" and "Mar", the words "Jan" and "Mar" will be displayed on the Pivot
Chart.

Thank you in advance for your help.

Show the item selected from Report Filter in a Pivot Chart
 

Hi,

There is no built-in feature to do that.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Mally" wrote:

Hi

I use Excel 2007. I have a pivot table set up with a Report Filter showing
all the months of the year.

Is it possible if I select the items from the Report Filter, for example
"Jan" and "Mar", the words "Jan" and "Mar" will be displayed on the Pivot
Chart.

Thank you in advance for your help.

Show the item selected from Report Filter in a Pivot Chart
 

Thanks for your help Shane

"Shane Devenshire" wrote:

Hi,

There is no built-in feature to do that.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Mally" wrote:

Hi

I use Excel 2007. I have a pivot table set up with a Report Filter showing
all the months of the year.

Is it possible if I select the items from the Report Filter, for example
"Jan" and "Mar", the words "Jan" and "Mar" will be displayed on the Pivot
Chart.

Thank you in advance for your help.

Show the item selected from Report Filter in a Pivot Chart
 

Easy enough with some Excel 2007 code:
http://www.mediafire.com/file/hmconm...01_21_09a.xlsm