i have one table of data formatted as a table.

when i click on a cell in the table and insert > pivot chart, and place that chart / table on an existing worksheet, the chart is linked to a different pivot table (not the new one that was just created)...

I have a sheet that contains the pivot tables for about 10 charts on various other worksheets.

i am using a template as a default chart.

everything worked fine until now, but now, when i try to create a chart the same way i had been (by clicking any cell in the table, and selecting "insert" "pivot chart") a new chart and table are created, but the chart is linked to "PivotTable1", and the new table, which usually corresponds to the new chart, is "PivotTable12" or something... If i click on the chart and change the pivot data, it alters the results in "PivotTable1", thus altering the chart which is already linked to that table.

somehow, when i try to create a new pivot chart, i get a new chart and table, but the chart is not linked to the new table...

hope this makes sense...

thanks for the help,

Phil