EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Excel Chart Templates
Secondary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course

Excel Chart Templates

By Madhuri ThakurMadhuri Thakur

Chart Templates in Excel

Chart Templates (Tables of Contents)

  • Chart Templates in Excel
  • #1 – How to Create a Chart or Graph Templates in Excel?
  • #2 – How to Use the Saved Chart Templates in Excel?
  • #3 – How to Set a Default Chart Template in Excel?
  • #4 – How to Delete a Chart Template in Excel?

Chart Templates in Excel

The following article provides an outline for Excel Chart Templates. Pictures can communicate more than you do with words. This increases the visibility of the data that you want to present. This is the reason we use a chart or graph template with excel. Instead of showing complicated data, a precise form of a chart is preferred. Excel provides a variety of options to deal with charts. The challenge is opting for the appropriate style, which perfectly matches the data you want to showcase.

A graph represents numerical data graphically. This may include symbols like a bar, lines, slices, etc. Apart from the built-in styles, excel offers customizable chart or graph templates.

How to Create a Chart or Graph Templates in Excel?

With the available styles, you can create a chart or graph and if you want to make it as a template for further use, have the option to save the created graph as a template in excel. This will help you to process the same kind of data further.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,813 ratings)
You can download this Chart Excel Template here – Chart Excel Template

Below is an example of making a customized chart and save it as a template in excel.

  • It is given sales done for a year in different months. The sales are done in Kg, and the price is given.

Chart Excel Template 1-1

  • By using this table, we need to create a graph. Here it contains the variables or components as Month, Unit sold, Price. And we expect these three in the same graph.
  • Select the entire data which you want to insert into the graph. Go to the Insert menu. Click on Recommended Charts.

Chart Excel Template 1-2

  • Here you will get the customizable charts according to the data you want to represent.
  • You will get two different tabs, Select All Charts from the pop-up window.

Chart Excel Template 1-3

  • Go to the Combo option.

Chart Excel Template 1-4

  • You can select the pre-defined graphs to start quickly. At the top of the dialog box, you can see the built-in styles.
  • Click on the second style Clustered Column – Line on Secondary Axis. The given data (Qty, Price) have different scales and need a secondary axis to get a clear view of the data. So give a tick in the column which you want to represent as a secondary axis. Click the OK button.

Chart Excel Template 1-5

  • The final chart will be as below.

Chart Excel Template 1-6

  • The X-axis shows the months and Y as sales, which is the secondary axis that shows the month and sales price. This makes a perfect match for the data given in the table.
  • To give more finishing touches, insert the axis titles. Click on the ‘+’ symbol. You will get the option to add Axis Titles; it will appear on each axis; double click on it and type the title you want.

Chart Excel Template 1-7

  • The final view will be as below.

Chart Excel Template 1-8

  • To save this chart as a template right click on the chart. Click on the Save as a Template.

Chart Excel Template 1-9

  • You will get the dialog box to select the location where you want to save the chart excel template. But to get it within excel have saved the file in the AppData\Microsoft\Templates\Charts, which is the default location for templates.
  • Give any related name and click the Save button. The file will be saved as a .crtx file, which indicates a template file.

Chart Excel Template 1-10

How to Use the Saved Chart Template in Excel?

Whenever you are using the same type of data, you can go with the saved templates to generate the chart in excel.

  • Once you selected the column of data that you want to make it as a graph. Go to the Insert menu, then Recommended Charts.

Chart Excel Template 2-1

  • Click on the All Charts tab.

Chart Excel Template 2-2

  • You can see the below-listed. Select the Templates folder.

Chart Excel Template 2-3

  • Once you select the template folder, you will get the saved templates under My Templates. Select the template and click OK.

CE Template 2-4

  • You will get the same saved chart templates and can be applied with the data you want.

CE Template 2-5

How to Set a Default Chart Template in Excel?

The default chart type is a two-dimensional column chart in excel. It is possible to set a saved template as your default chart.

  • Select the data which you want to make as a graph. Go to Insert menu then Recommended Charts option.

CE Template 3-1

  • If you click the Templates folder from the All charts tab, the saved chart templates will be listed right next to it.

CE Template 3-2

  • Right-click on any of the templates. Click on the Set as Default Chart pop-up, then press the OK button.

CE Template 3-3

  • Now the template has been set as the default template.

How to Delete a Chart Template in Excel?

If you are no longer using a chart template, you have the option to delete the template using Manage templates.

  • Select the Insert menu go to the Recommended Charts option.

CE Template 4-1

  • Go to the All Charts tab. At the bottom of the dialog window, you can see a tab named Manage templates. Click on the Manage Templates button.

CE Template 4-2

  • The default location of the saved templates will be opened. You can see the saved templates here.

CE Template 4-3

  • If you want to delete any of this, select the template and right-click on the template. From the pop-up, you can select the delete option. Click on Delete.

CE Template 4-4

  • Now the chart template will be deleted from the saved templates.

Things to Remember 

  • Graph templates help to represent your data in a pre-designed graph in excel.
  • If you are daily using and generating the same type of chart with different data set, you can go with chart or graph templates in excel.
  • Any type of generated chart or graph can be saved as a template and can be reused in excel.
  • Once you save the templates within the default location, it is possible to use them as a template with any other data.
  • It is easy to manage the template; if you are no longer using a template, you have the option to delete it.

Recommended Articles

This has been a guide to Chart Templates in Excel. Here we discussed How to Create, Use, Delete, and Set a Default Chart or Graph Template in Excel along with practical examples and a downloadable excel template. You may also look at these suggested articles –

  1. Excel Clustered Column Chart
  2. Excel Combination Charts
  3. Estimate Template in Excel
  4. Free Excel Template
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Excel for Marketing Training (8 Courses, 13+ Projects)4.8
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Chart Excel Template

EDUCBA

Download Chart Excel Template

EDUCBA

डाउनलोड Chart Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more