Excel Chart Templates are great! When you need to use dynamic, interactive charts and graphs, this page is yours! With the help of data visualization, you can support the decision-makers.
Table of contents:
- How to build a chart template in Excel
- Basic Charts
- Advanced Chart Templates
All charts are free, and you can download and use them quickly. If you are working on an excel dashboard, you should have to use them.
How to build a chart template in Excel?
The goal is to build reusable charts! Things to do before create a chart template and modify existing charts:
- Get rid of junk parts: The newly inserted chart contains unwanted elements. If you are using proper chart formatting, you need to remove the extra legends, labels, borders, or grids.
- Create easy-to-read charts: To improve the readability, format the chart first. For example, remove the background, decrease the gap size between bars.
To create a custom chart and store it as a template, save the graph as a template! After that, open a new project: your saved chart template will appear and ready to use.
Steps to build a chart template in Excel:
- Create a default chart and customize it
- Right-click the selected chart, then select ‘Save as Template’
- In the File name box, add a name for the new chart template
- Click Save to save the chart as a chart template (*.crtx)
That’s easy! From now on, you’ll find your chart template in the templates folder.
How to use chart templates
OK, now we have a chart template; let’s see how to use it!
Steps to apply a chart template:
- Select the data that you want to display
- Click on ‘Recommended Charts’ under the Insert Tab
- Select the All Charts Tab
- Choose the template
- Click OK
How to manage chart Templates
All chart templates will be saved to your computer (local drive). You can find your prepared chart under the location below:
You can reach this folder directly also.
To get the Template Gallery from Excel, click the ‘Manage Templates’ button.
Delete the chart if it’s not necessary anymore.
Basic Chart Templates
Let us see the basics. If you are looking for ready-to-use chart templates, check the list below!
Market Segmentation Graph (Mekko Chart)
The Marimekko chart is the most powerful tool for taking a quick look at the overall market. It helps to drive discussions about growth opportunities and is also known as a market map. You can segment an industry or company by customer, region, or product. It makes it easy for your audience to understand each part or bar’s relationship to the total. The graph breaks down a market by combining multiple bars into a single map using a variable-width 100% stacked bar chart. In the example, you’ll learn how to convert sales data of each region across different products. It’s easy to calculate the individual parts of total sales. Download the sales map!
Conditional Bar Chart Template
Learn how to create a grouped chart to analyze the variance. Conditional formatting is a great feature in Excel; we recommend it highlighting the plan vs. actual data. In the example, the first series is based on the actual data for the sales of five products. Use the MAX function to find the largest data in a range. After that, highlight the maximum value using blue. The chart on the right side shows the variance. Let’s see the trick! Select the chart! Right-click and click ‘Format data series.’ Under the Fill group, select the ‘Invert if negative’ checkbox. Pick your preferred colors! If the value is positive, use green as usual. Elsewhere we’ll apply red. Right-click and choose the Group command from the context menu. That’s all! Take a closer look at the template and download the practice file.
Take a closer look at the small multiples graphs (aka panel charts). This tutorial will show how to create a proper layout for your data to create a panel chart in Microsoft Excel. Instead of a busy line or column charts, you’ll get a grouped graphs. To build sales comparisons, create your data table first. After that, summarize your data. Finally, calculate the position of the dividers for the x-axis. The best thing that you don’t need to use pivot tables. Download the practice file and create your report step by step.
Do you like infographics? Use the people graph instead of columns or bars to present your data set using shapes and icons. The result is a great-looking chart. So, it’s easy for you to tell a story based on your data. Please take a closer look at our latest infographics. The article provides free Excel chart resources. Excel 2013 and above versions are required to use this chart template. You can find the add-in under the ‘Insert Tab.’ Select the range which contains data, then click on the people graph icon. A new chart will appear; you can apply various formatting tricks like themes, shape styles, and colors.
The next one is a basic chart template. For example, you want to show the actual value and the forecasted value on the same graph in some cases. What’s the secret? Create three series and use the IF function. If the latest data point (value) is greater than the actual value, apply a green arrow, elsewhere use a red marker. To build it, we’ll use a combination of three simple line charts to create a forecast. Read the guide!
This small in-cell graph fit in a single cell but show powerful insights! It does not chart objects; instead, they exist as a shape within a cell.
Advanced Chart Templates
This section is built for pros. You can build all of the demonstrated charts from the ground up but recommend using free templates.
The gauge chart’s logic (speedometer) is very simple: it provides information about a single data point (value). It’s easy to compare the actual value to a goal (plan value) using red, yellow, and green colors. We have said quite many times that why we love this chart type.
Good to know: Dual Gauge can display more thane one KPI, and it’s great for plan vs. actual purposes. Gauge charts are easy to read and grab the attention of the audience. The chart is widely used in BI.
What are bullet graphs? A bullet graph is a great alternative to gauges. The graph transforms data using length and height, position, and color to show actual vs. target using bands. Save more space using bullet graphs! Tell a story using segmented bar charts to display complex data. In our detailed guide, you can learn all about how to track progress easily. Check the example!
This template is a bit special. If you are working with Microsoft Excel, you’ll face some limits. Build a company structure from the ground up using SmartArt (built-in shape objects) is a time-consuming task. How to speed up your daily work and routine tasks? We know the right answer. Use our free chart add-in and built an org structure in seconds. You’ll find a useful article about how to build a human map using powerful VBA tools. Get the add-in!
Traffic Light Chart Template
If you are in Project Management, you have various tricks to track a project and show the actual status. First, you can apply a formula-based rule and traffic light icons in conditional formatting. Furthermore, there are color-formatted shapes to highlight the KPIs. The best way to implement a stoplight is using automated charts. Learn how to use our free widgets and manage multiple indicators at the same time. It’s a very easy reporting tool. Download
Stay tuned and read more about chart templates!