Cannot change criteria on copied chart without changing original c
 

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

Cannot change criteria on copied chart without changing original c
 

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

http://PeltierTech.com/
_______


"Steve" wrote in message
...
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