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