PivotChart keeps duplicating

[alyons]

All,

I am at a loss. I have scoured google for two hours and cannot find a solution.

We have metrics being loaded into spreadsheet 1. We are then summarizing that data into a PivotTable and displaying that into a PivotChart on SharePoint...

The problem is, the chart constantly duplicates itself and slows the SharePoint page to a crawl. Then I have to go into the spreadsheet and delete 200 charts that are hidden behind the chart that we use. I'm guessing that the "Refresh data when opening the file" option recreates the chart every time it is opened but I'm not sure. You can see that its the same chart, just with different formatting. Has anyone seen this, or know of a solution?


I have inserted a small version of the file. If you navigate to the "people" tab, you can see two of the charts... The top chart is supposed to remain. I had to delete 200 of the charts behind it.. They keep replicating.

Ive noticed that when I click through the charts some say "Picture #" and some say "Chart #".. I'm at a loss..
I have saved it locally from SharePoint and cannot replicate the issue. Could the AutoPublish feature on SharePoint make this happen? We don't have issues anywhere else...

Adam