Formatting Multiple Pivot Charts

[Lol123]

Dear Experts

- Objective: I have a lot of data (completed tasks of employees) in one sheet and need to create for each employee a chart about their performance.

- My approach: Create a pivot table for each employee and then create a chart for each pivot table.

- Problem: Every pivot chart needs to be formatted the same way. Hence, I copy any part inside a chart and paste it anywhere inside the new chart (it pastes the complete formatting). Unfortunately, this only works in around 90% of the cases. There are 2-3 charts that do not allow to be formatted, instead they take over the content of another chart (not even the one I copied!). If I change the filter of the new chart to show the correct employee the other chart whose content was pasted also changes to the new employee. I tried to delete the pivot table as well as the chart and create them from scratch – the same happens.

What’s different with these charts that can’t be formatted by copy and paste? How can I format them efficiently?

Many thanks in advance!

[scottiex]

is the formatting protected on the chart?

http://peltiertech.com/Excel/ChartsH...rotection.html