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

51,648

Solution 1

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

Solution 2

Your saved templates are under Change Chart Type --> Other, you just have to scroll down below the radar charts. I know, not very intuitive....

Share:
51,648
Cristi
Author by

Cristi

Updated on June 14, 2020

Comments

  • Cristi
    Cristi almost 4 years

    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?