Select Save as Template. Save a file with a CRTX extension in your default Microsoft Excel Templates folder. Once that's done, simply reapply that template to new charts. Select the data you want ...