Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 73
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 73
Default 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.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,180
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show selected filter in a pivot chart (2007 version) Atri Excel Discussion (Misc queries) 0 December 16th 08 08:47 PM
How to set up pivot to show name of series item in bar chart Lin, PMP, NJ Charts and Charting in Excel 0 November 28th 07 04:14 PM
FILTER FUNCTION DOES NOT SHOW TOTAL RECORDS SELECTED MUSANDAI Excel Worksheet Functions 2 October 18th 07 05:04 PM
Create interactive pivot table chart based on item selected Sacto Harley Charts and Charting in Excel 0 October 10th 07 10:50 PM
Print Pivottable - show all selected items in page filter Koen Excel Discussion (Misc queries) 0 June 19th 06 09:30 AM


All times are GMT +1. The time now is 06:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"