Help for setting pivotChart

[BG66]

Hi everyone from Italy.

First, sorry for my bad English. I hope you can understand my problem anyway.

I need to link the pivot chart to the drop down menu (see the attachment http://dropcanvas.com/j08th )
PS I cannot use the automatic slicers because I work with Excel 2007.

Thanks in advance.

 

[NARAYANK991]

Hi ,

Nothing is clear. Can you mention the cells which have the dropdown menu ?

Narayan

 

[BG66]

Hi,
new version http://dropcanvas.com/174s5

Answer to your question:
in B3 and B17 -> dropdown menu
+ one pivot report filter (Q19 zone)--> fist test after lesson video (http://chandoo.org/wp/2011/04/27/update-report-filter-macro/) but at the time I did not understand how to merge the report filter to the pivot chart for dynamic chart.

Tx
BG

 

[BG66]

Hi,
new version http://dropcanvas.com/174s5

Answer to your question:
in B3 and C17 -> dropdown menu
+ one pivot report filter (Q19 zone)--> fist test after lesson video (http://chandoo.org/wp/2011/04/27/update-report-filter-macro/) but at the time I did not understand how to merge the report filter to the pivot chart for dynamic chart.

Tx
BG