Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I've saved Excel chart templates, but whenever I use them again I have to re-type the axis labels. Is there a way to save the label in the template?

share|improve this question
    
Have you tried typing them in and save as - template again? –  Raystafarian Mar 1 '12 at 1:08
    
@Raystafarian - yes; but it doesn't save it! –  Chris Mar 10 '12 at 9:55

3 Answers 3

up vote 1 down vote accepted

Unfortunately, you can't. :(

It also should be noted that chart templates do not save customer data, preventing customer information from being copied and saved into template files (customer data includes: data point and series values, text on titles, etc.). Although data is not saved, the existence, formatting, and layout of all elements is stored in the template.

http://blogs.office.com/b/microsoft-excel/archive/2008/02/21/chart-templates.aspx

share|improve this answer

There is a workaround for this:

1) Create a chart with the title position and axis label positions you wish.

2) Insert a text box for each label/title with the label text and formatting you wish, on top of the default titles. Fill the text boxes with the same color as the chart background, select "no outline" for the text boxes. It is a good idea to make all these text boxes larger than the default titles so you will not click the default titles accitentally i you want to change the texts.

3) Save the chart as a template.

share|improve this answer

Use Paste Special to re-use chart axis labels: http://chandoo.org/wp/2010/02/24/paste-special-chart-formatting/

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.