I'm a newbie to this site but have been using excel for many years. I have a question regarding pivot charts and tables.

I'm wondering if there is a way to have the chart work independently from the pivot table. My pivot table is designed/layed-out in a certain way but the moment I make changes to the pivot chart by switching row/column the pivot-table layout also changes.

Is there a way to disconnect the two but still have the pivot-chart read the data off the pivot-table?

Any help would be appreciated.

Thanks in advance.