Hi all.
I´m gettin mad with this issue,any help would be great for me.
The point is.
I want to set a image to fill a PIVOTCHART serie,I will distribute this excel sheet among many people so I need this picture to be embedded,this series dates are changing so i need to use VBA.

I hope you know what I mind till now.. so I continue..
Well i tried with this code:

sheet1.shapes("myimage").copy
Sheet1.ChartObjects(1).Chart.SeriesCollection(1).P aste

And this works just if the chart is not linked to a pivot table.
If i try with a pivotchart i get error
If then I delete the pivottable ans try again code works..
But i need the chart to be linked to a Pivottable
What can I do?
Thanks in advance