How To Make A Plot From Template Excel
Bottom line: Larn how to use Nautical chart Templates in Excel to chop-chop apply formatting and settings to new and existing charts. Includes instructional videos.
Skill level: Beginner
Cleanup the Chart Junk
The default chart formatting in Excel typically includes a lot of actress elements that aren't ever needed for our charts. A nicely formatted chart should include but the minimal corporeality of elements (legend, axis, labels, gridlines, etc.). This makes the nautical chart easier to read, and allows the data to tell the story.
Entire books have been written on the principles of data visualization, then I won't become into a lot of detail here. The main idea is that we should utilise a minimalist arroyo to creating and designing charts (graphs). All the extra formatting is typically referred to as chart junk considering it clutters upward the chart and distracts the reader.
To acquire more about this topic checkout the books by Edward Tufte and Stephen Few (Amazon links). My good friend Mynda Treacy from MyOnlineTrainingHub also covers these principles in her Dashboards Course.
Chart Templates to the Rescue
Fifty-fifty if you don't follow these principles, it'south likely that the default chart formatting doesn't match your needs. Subsequently inserting a chart on a canvas, we typically take additional steps to format it.
This can be time consuming. My typical process to cleanup a Bar PivotChart includes a minimum of seven steps and a total of eighteen+ mouse/key presses.
- Hide All Field Buttons
- Delete the Legend
- Delete the Axis Labels
- Delete the Gridlines
- Add together Data Labels
- Reduce Gap Width
- Categories in reverse order
That's a lot of extra work and time!
Fortunately, we can automate this process with Nautical chart Templates. We tin save all the formatting options and settings to a Chart Template, and and then apply the template to whatever new or existing nautical chart.
If yous'd like to larn how to create that pivot table and chart, checkout my complimentary videos series on pin tables and dashboards for Excel.
How to Create a Chart Template
To create a Chart Template:
- Insert a chart and change the formatting to prepare it for presentation.
- Correct-click the chart and choose "Salvage as Template…".
- The Save Chart Template window will open. Proper noun the Chart Template File.
- Click Relieve.
The Nautical chart Template will now be available in the Chart Template Gallery on the Insert/Alter Chart Window.
How to Apply Chart Templates
Now that you lot have created a Chart Template, yous can utilize to it any new or existing chart.
To use the Chart Template to a new nautical chart:
- Click a Chart button on the Insert tab of the ribbon to open the Insert Chart window.
- Click the Templates tab on the left sidebar.
- You volition run across a gallery of your Nautical chart Templates. Select the one you want to use to create the chart.
- Press OK.
- A new chart will exist inserted on the sail and all of the Template's formatting options will be applied.
To apply the Chart Template to an existing chart:
- Right-click the existing chart and choose "Alter Chart Type…".
- The Change Chart Type window will open. Click the Templates tab on the left sidebar.
- Select the Chart Template you want to utilise.
- Press OK.
- The nautical chart type and formatting volition be applied to the existing chart.
How to Manage Chart Templates
The Chart Templates are saved as crtx (nautical chart template) files to your computer. They are typically saved in the following location on your computer.
C:\Users\[username]\AppData\Roaming\Microsoft\Templates\Charts
You tin can get to this location from the Chart Template Gallery past clicking the "Manage Templates…" button in the bottom left corner of the Insert/Change Chart Window.
That opens Windows Explorer and navigates to the Chart Templates folder. From here you can add or delete chart template files.
If you lot downloaded a crtx (chart template) file or received i from a co-worker, you can copy the file into this binder. It will then appear adjacent time y'all open the Template Gallery.
Download the Chart Template
You tin can download the Chart Template I use for Bar PivotCharts below.
PivotChart Bar.crtx (vii.viii KB)
Nautical chart Templates for Each Chart Type
It's important to note that the Nautical chart Template besides includes the chart blazon (bar, column, line, pie, etc.). So you lot will demand to create a Chart Template for each chart type you utilize frequently. You might have split up templates for bar, column, line, combo charts, etc.
You might also want to create templates for unlike projects or reports yous piece of work on periodically. Any time you modify a chart and are happy with the results, right-click and "Salvage as Template…" This volition make it easier to speedily utilize all those settings in the future.
Sharing Chart Templates for Consistency
Some other benefit of Chart Templates is that y'all tin create consistent looking charts throughout your department/squad/organization. Once you create a Chart Template, you tin can send the crtx file to everyone and have them use it on all their charts. This volition ensure every chart uses the aforementioned colors, fonts, formatting, etc.
The video above contains instructions on how to import a Chart Template file. You can share this with your team when you send them a template file.
What practice y'all use Chart Templates for?
Chart Templates definitely save usa time past allowing us to create our own default formats. We might have to take a few extra steps to format the chart, depending on the project, but the template gives us a good starting point to piece of work with. They likewise help create consistency inside your organization.
How practice you use Chart Templates? Delight leave a annotate below with any questions or suggestions. Thank you! 🙂
How To Make A Plot From Template Excel,
Source: https://www.excelcampus.com/charts/chart-templates-default-formatting/
Posted by: roseselven54.blogspot.com
0 Response to "How To Make A Plot From Template Excel"
Post a Comment