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

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...