multiple pivotcharts from 1 pivot table?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JJeter - 09 Oct 2007 00:12 GMT

I have a pivot table that I need to generate several charts from and I need
for each chart not to change when I change the data in the table. Is there a
way to do this? All of these charts will be in the same workbook.

Reply to this Message

Debra Dalgleish - 09 Oct 2007 15:37 GMT

Each chart will change when the pivot table on which it's based changes.
Make a copy of the pivot table for each chart that you need, and base
each chart on a copy.

> I have a pivot table that I need to generate several charts from and I need
> for each chart not to change when I change the data in the table. Is there a
> way to do this? All of these charts will be in the same workbook.

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

JJeter - 09 Oct 2007 16:09 GMT

Debra,

I could have sworn that I saw somewhere that a PivotChart could be copied
and made static so that it wouldn't change when the original Pivot Table
changed.

Thank you for your response.

Jim Jeter

> Each chart will change when the pivot table on which it's based changes.
> Make a copy of the pivot table for each chart that you need, and base
[quoted text clipped - 3 lines]
> > for each chart not to change when I change the data in the table. Is there a
> > way to do this? All of these charts will be in the same workbook.

Reply to this Message

Debra Dalgleish - 09 Oct 2007 16:28 GMT

Sorry, I thought you wanted each chart's layout to remain the same, if
the pivot table's layout changed.

If you want a static chart, copy the chart, and paste it into a new
workbook. Then, cut it from the new workbook, and paste it back into the
original workbook.

> Debra,
>
[quoted text clipped - 13 lines]
>>>for each chart not to change when I change the data in the table. Is there a
>>>way to do this? All of these charts will be in the same workbook.

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

JJeter - 09 Oct 2007 19:02 GMT

Debra,

Thank you. That seems almost too simple. :)

I'll give it a shot.

> Sorry, I thought you wanted each chart's layout to remain the same, if
> the pivot table's layout changed.
[quoted text clipped - 20 lines]
> >>>for each chart not to change when I change the data in the table. Is there a
> >>>way to do this? All of these charts will be in the same workbook.

Reply to this Message