How to apply a saved chart template to an existing chart?

excel templates charts contour excel-2011
Cristi picture Cristi · Jun 30, 2013 · Viewed 50k times · Source

I recently created a custom contour chart in excel to display my data colored with a heat-map color mapping. I'm using a Excel 2011 on a Mac. I can't find a way to reuse the saved template. The help instructs me to

  1. Click the chart
  2. On the Charts tab, under Change Chart Type, click Other, and then under Templates, click the chart template that you created.

There is no "Templates" Icon Group or an entry in the menu.

What am I missing here?

Answer

Pierre picture Pierre · Aug 7, 2013

It is really not obvious!

You have to scroll down the chart type list (toolbar Charts/button Other) The saved templates are "hidden" at the very end of the list.

=>It is especially handy when you need to draw many of the same charts.

Yes, on the other side to save a chart as template you just need to: - Right click on the finished chart or - Select the menu Chart/Save as template...

Related questions

EPPlus - How to use a template

I have recently discovered EPPlus (http://epplus.codeplex.com/). I have an excel .xlsx file in my project with all the styled column headers. I read on their site that you can use templates. Does anyone know how or can …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More