Share via

How do I create an excel chart template with titles?

Anonymous
2011-06-28T19:35:46+00:00

I need to create numerous charts with an identical data format, titles, data labels &  axis labels.  For this purpose I use a template, however, the template does not retain the title, data labels and axis labels.  I am now using Excel 2010.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-06-16T10:33:41+00:00

    I need to create numerous charts with an identical data format, titles, data labels &  axis labels.  For this purpose I use a template, however, the template does not retain the title, data labels and axis labels.  I am now using Excel 2010.

    Use Paste Special to Speed up Chart Formatting:

    http://chandoo.org/wp/2010/02/24/paste-special-chart-formatting/

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2011-06-29T11:52:35+00:00

    if by template you mean a crtx file then the titles will not be retained as it is considered customer data.

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

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-06-29T11:20:39+00:00

    Did you create this template or was the template downloaded from a website/program?

    In which format is the template saved? .xlt or .xltx ?

    Try creating a new Excel chart template and check if the issue re-occurs.

    Was this answer helpful?

    0 comments