Sep 28, 2015
A picture says a 1000 words… or so the saying goes. Charts are a popular way for people to graphically represent data when trying to emphasise trends and generally improve how people perceive data.
It is important that a chart look professional, clear and impart a message (the 1000 words bit). The look is often constrained by a corporate colour scheme, fonts and other formatting elements. Consistency is very important, especially if the charts are made available to the public.
A chart template is a file that contains formatting and layout settings that can be used to create new charts in seconds with all the corporate feels of the original.
The hard part of creating one of these templates is formatting the first one – the one the template is created from. After that, it’s easy.
Here are the steps:
- Create a chart with the following established:
- Type of chart (column, pie, line, etc.)
- The formatting (colours used, fonts used, etc.)
- The layout (legend position, data labels, etc)
- In Excel 2007 or 2010: On the Design tab of the Ribbon click Save As Template… In Excel 2013 or 2016: Right click on the chart and choose Save As Template…
- Type a name for the template that describes the type of chart
- Click Save
So, when you want to create a new chart using the Chart Template as a basis, follow these steps:
- Select the range of data that you want to create the chart on (as normal)
- Go to the Insert tab on the Ribbon and click the Dialog Box Launcher at the lower right corner of the Charts group
- Click the Templates category at the top left
- Choose the template you want to base your chart on
And hey, presto – a replica of your old chart appears! Easy!
For more information, have a look at New Horizons' Excel training courses.
How do your Excel skills stack up?
Test NowNext up:
- Cascaded Dropdowns in Nintex Forms
- The Aussie Meat Pie of Managing Teams
- Introduction to Office 365 Video
- Entity Framework Code-First
- The awesomeness that is AngularJS – Part 1
- What Customers Want
- Deleting an undelete-able site collection
- Non-Breaking Spaces & Non-Breaking Hyphens in Word
- Creating a simple Website and User Interface with MVC – Part 1
- Welcome to the new Edge
Previously
- Setting up your models in MVC
- No need for meeting notes anymore!
- “If you can’t measure it…”
- The best features in Office 2016!
- Use a slicer to make better business decisions
- What’s a JavaScript Closure?
- Put that marker down and Redact in Acrobat please!
- Understanding your customers with 6 questions
- New security features in Windows 10
- All About VLOOKUP() in Excel