Chart Title in Template?

[sammipd]

I’m creating a workbook with 4 pivot tables on each of 50+ worksheets, all based on the same masterdata sheet. I’ve created templates for the pivot chart associated with each table. The problem is the Chart Title does not save with the template. I tried a macro to add the Title after the template creates the chart, but that didn’t work.

Please, any suggestions?

[Andy Pope]

The template will only store the formatting of the chart title rather than any static text.

What you could do if the chart title text is to be static is insert a textbox into the chart before you save as template.

If not maybe you can post the code you tried to use

[sammipd]

Thank you Andy, inserting a textbox as the Chart Title works fine!

Could you continue to help please? There are 50+ worksheets to add this chart to and I'm looking for a method to speed this up. To add the template to each page requires several clicks. I recorded a macro to do so and the data comes through correctly, but the formatting doesn't. There's no problem with the formatting if I add the template individually to each page. How can I adjust this?