Hi there,

I have a spreadsheet which contains multiple pivot charts displaying data from the same table & connection. I'm using PowerPivot.

The spreadsheet is meant to be a dashboard and each pivot chart displays the data using a different approach (e.g., I have one for median, one for 75th percentile, one for histogram, one for raw count by date, etc..).

After adding a couple of tables and spending quite some time configuring design and selecting the right fields for each one, at some point, midway through configuring a new chart, the act of adding a new field or changing the background color seems to link the current chart to another one in the worksheet. The new chart simply morphs into the other existing one. Design, fields and data from the current chart are gone and it seems as if new and old charts are both references to the same chart. Any change I make to the old chart reflects on the new one, and vice-versa. This has happened quite a few times, and I could not identify a patterns of actions that takes to this issue. The only way out is to remove the chart and re-add it, performing tasks in a different order.

As my dashboard gets more complex, I cannot keep relying on trial and error to get this working.

Any suggestions on what might be causing this?

Tks,

Hi There,

I realize this is an old unanswered question, however I am having the exact same problems using Windows 8.1, Excel 2013 Professional Plus 32 Bit.

I have posted the same problem on the office forum (http://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/powerpivot-and-a-large-number-of-charts-in/cbe1cea4-4952-4d3c-b92e-3952f15d1622) to be directed to this one.

Just wondering if anyone has made any progress with finding a solution.

Thanks.