{"id":95,"date":"2018-02-12T14:59:50","date_gmt":"2018-02-12T14:59:50","guid":{"rendered":"https:\/\/www.spreadsheet123.com\/blog\/?p=95"},"modified":"2018-06-25T08:39:56","modified_gmt":"2018-06-25T08:39:56","slug":"save-time-with-excel-chart-templates","status":"publish","type":"post","link":"https:\/\/www.spreadsheet123.com\/blog\/excel-help\/save-time-with-excel-chart-templates","title":{"rendered":"Save Time with Excel Chart Templates"},"content":{"rendered":"
\"Excel<\/div>\n

Did you know you can create your own Excel chart templates? With a chart template, you format it once and then use it again and again. You can even set it as your default chart.<\/p>\n

They\u2019re great if you typically spend a few minutes on each chart formatting the colors, fonts, axis labels, etc., which many of us do to keep our reports in line with company branding.<\/p>\n

Or maybe you don\u2019t like the technicolor default chart formats, after all, they\u2019re not great. Just look at the one below.<\/p>\n\"Excel\n

Any Excel user worth their salt will be making some formatting changes to create a more elegant chart that doesn\u2019t overwhelm their readers:<\/p>\n\"Chart\n

The softer grey formatting of the axis labels, legend, and title in the above chart result in the columns being the most prominent information \u2013 just as it should be.<\/p>\n

Setting Up a Chart Template<\/h2>\n

To set up a chart so that it\u2019s available as a Chart Template is easy:<\/p>\n

    \n
  1. \n
      \n
    1. Format your chart the way you want.<\/li>\n
    2. In Excel 2007\/2010: with the chart selected to go to the Chart Tools: Design tab of the ribbon and click \u2018Save As Template\u2019:<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n\"Saving\n

      In Excel 2013 right-click the chart and select \u2018Save as Template\u2019:<\/p>\n\"Saving\n

        \n
      1. \n
          \n
        1. The \u2018Save Chart Template\u2019 dialog box will open. Give your chart file a name and click \u2018Save\u2019. Note: the \u2018Save as type\u2019 will be set to .crtx and the folder path will be your Microsoft\/Templates\/Charts:<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n\"Saving\n

          Using Chart Templates<\/h2>\n

          Now that you\u2019ve set up a template you can find it in the Insert Chart dialog box:<\/p>\n\"Using\n

          Editing Chart Templates<\/h2>\n

          If you want to delete or rename templates, you can click on the \u2018Manage Templates\u2019 button in the \u2018Insert Chart\u2019 dialog box, and the folder containing your templates will open.<\/p>\n\"Managing\n

          Setting Your Default Chart<\/h2>\n

          If you want to set this chart as your default chart simply select it in the \u2018My Templates\u2019 list and then click the \u2018Set as Default Chart\u2019 button.<\/p>\n\"Setting\n

          Now when you press ALT+F1 to insert a chart, you\u2019ll get your new Default chart nicely formatted just as you like<\/p>\n","protected":false},"excerpt":{"rendered":"

          In Excel create your very own Excel chart templates, customize charts with colors that matches your brand or task specific requirements. Format your chart only once, create different variations of the frequiently used charts, then save them as templates and use time and time again.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[8],"tags":[],"class_list":{"0":"post-95","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-excel-help"},"_links":{"self":[{"href":"https:\/\/www.spreadsheet123.com\/blog\/wp-json\/wp\/v2\/posts\/95","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.spreadsheet123.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.spreadsheet123.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.spreadsheet123.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.spreadsheet123.com\/blog\/wp-json\/wp\/v2\/comments?post=95"}],"version-history":[{"count":0,"href":"https:\/\/www.spreadsheet123.com\/blog\/wp-json\/wp\/v2\/posts\/95\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.spreadsheet123.com\/blog\/wp-json\/wp\/v2\/media?parent=95"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.spreadsheet123.com\/blog\/wp-json\/wp\/v2\/categories?post=95"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.spreadsheet123.com\/blog\/wp-json\/wp\/v2\/tags?post=95"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}