Cannot change criteria on copied chart without changing original c

[Steve]

I have a chart that I created from a pivot table. Instead of creating 40
plus charts individually, I tried to copy the original chart and change the
location for each chart. When I change the facility location for one chart
it changes all others. How can I get around this?

Steve

 

[Jon Peltier]

You'll need to make independent pivot tables for each chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
774-275-0064
208-485-0691 fax
(e-mail address removed)
http://PeltierTech.com/
_______