WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Chart Templates in Excel

Chart Templates in Excel

How to Create Chart Templates in Excel?

A template is actually a sample chart that has some details already mentioned in it and can be reused when the same chart is required to be used again.

Step by Step with Examples

You can download this Excel Chart Templates here – Excel Chart Templates

Example #1 – Create a Chart Template using Pie Chart

Consider the following data we have below, and follow the steps

Chart Template Example 1

Step 1 – Select the data we want to insert in the chart then, Click on Charts in the Insert tab under the charts group select Pie Chart in excel.

Chart Template Example 1-1

  • Step 2 – In the Pie Chart, select a 3-D Pie chart.

Chart Template Example 1-2

The chart for the above data is created.

Chart Template Example 1-3

  • Step 3 – Customize the chart by adding data labels from the “+” option provided.

Chart Template Example 1-4

  • Step 4 – And stretch the chart.

Chart Template Example 1-5

  • Step 5 – Now right click on the chart, and a wizard box appears. Click on Save as Template.

Chart Template Example 1-6

  • Step 6 – It asks for a chart name to be saved in the charts template. Name the chart and save it. I have named my chart as a “sample.”

Chart Template Example 1-7

Step 7 – Now consider the below data, which is different from the previous one.

Chart Template Example 1-8

  • Step 8 – Now select this data and click on all charts.

Chart Template Example 1-9

  • Step 9 – A dialog box appears,

Chart Template Example 1-10

  • Step 10 – Click on Templates; we can see our created template, which was named as a sample. Click on OK.

Chart Template Example 1-11

See the result.

Chart Template Example 1-12

The same chart is created from the template, and we did not have to re-do the whole drag the chart and insert the data label again. This is how we use the chart templates.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example #2 – Create a Chart Template using Pareto Chart

Now earlier, we had used a pie chart, which was a simple chart. In the second example, we will use the Pareto chart to describe the use of creating an Excel chart template. (Pareto chart is a data analysis tool for finding the root cause of something).

We will have two data for Pareto and create an excel chart template from the first data and then use the template for the second data to create the Pareto chart.

Consider the data below,

Chart Template Example 2

We have two sets of data of Pareto analysis, and we will make the Pareto chart for the first data and save it as a template to use it on another data.

  • Select A, C & D column, then click on Recommended charts in the charts section under the Insert Tab.

Chart Template Example 2-1

  • The wizard box for all charts appears; click on Combo charts in excel.

Example 2-2

  • Select Cumulative frequency % as the secondary axis then click on OK.

Example 2-3

See the chart.

Example 2-4

  • Let us edit the chart a little bit, Insert data labels from the “+” sign provided as shown in the above example.

Example 2-5

  • Now right click on the chart and the wizard chart box to edit the chart appears, click on Save as Templates.

Example 2-6

  • A browse box appears, name this template as sample 2 and click on ok to save it. Always remember to give different names for templates to be precise, which chart needs to be re-used again.

Example 2-7

Now we have saved our chart template for the Pareto chart.

  • Now select the data for the second chart to be created, i.e., J, L, and M column. Again, click on All charts.

Example 2-8

  • From the dialog box of all charts, click on templates and select Sample 2, the second template created.

Example 2-9

When we click on ok, we can see the Pareto chart for the second data is also created with respect to the first chart.

Chart Template Example 2-10

We can see that even if we have complex charts to recreate, we can use templates to create them once and re-use them whenever required.

Things to Remember

  1. We need to design one chart as a sample Excel chart template.
  2. Always name different graph templates uniquely so that we can have a specific idea which template to use when.
  3. The Excel Graph templates are saved in the system itself, so it will work in the same system we saved the template.
  4. The Excel Chart template contains all the formatting done earlier, so in case we need to change the format of the chart, we have to do it manually.

Recommended Articles

This has been a guide to Chart Templates in Excel. Here we discuss how to create graph templates in Excel with practical examples and a downloadable excel template. You may learn more about excel from the following articles –

  • Combo Chart in Excel
  • How to Make Pie Chart in Excel?
  • Top Types of Charts in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Excel Chart Templates

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More