Pivot Charts: Leave Pivot Table Same

[numberpro]

Hey guys,

I really like the flexible feature of pivot charts, but sometimes, I would like to create a pivot chart and leave the pivot table in a set format. That is, as I make changes to the pivot chart, I want the pivot table to stay in the original format. Is there a way to do this?

Thanks in advance!

 

[robweis62]

I was searching for the same problem....I found the following technote on Microsofts site

http://support.microsoft.com/default.aspx?scid=kb;en-us;215904&Product=xlw