I have 2 sheets in Excel. Sheet 1 is my pivot table and Sheet 2 is the Pivotchart linked to the pivot table. What I need is to add different images on to the Pivotchart but which image to insert depends on what value has been selected in the pivot table filter.
Any ideas how to write this code?
Thanks
Any ideas how to write this code?
Thanks