It is currently impossible to take a Pivot-Chart and make a copy of it which is linked to another (nearly-identical or quite-different) Pivot-Table, on another sheet. Such copying would be useful one dealing with several Pivot-Tables when you want each to have a similar chart. Note that this is different than creating a copy of both a table and a chart (bug 16217).