Chart title changes as per selected slicer

[ashish mehra]

Hi,

I want to link Chart Title to the slicer selection. How can I link?

Regards,
AM

 

[Nebu]

Hi:

Create another pivot and link it to the slicer you use to manipulate your chart and pick the title from this newly created pivot by giving cell reference.

Thanks

 

[ashish mehra]

Hi Nebu,

It works. Thanks for the tip.

Regards,
AM

 

[NARAYANK991]

Hi Ashish ,

If you do not mind VBA , this is an alternative method.

Narayan

 

[ashish mehra]

Thanks Narayan

This is what I need.

Regards,
AM

 

[finlain]

Great thank you!

 

[Martina Hawkins]

This is a great solution but when I add another pivot table and chart on the same worksheet it doesn't work. I would like a solution where I can use the same slicer for all pivot charts or have a different slicer for each chart. Error: run time error 5, Invalid procedure call or argument. Any suggestions please?