![]() ![]() The Save Chart Template window will open.Right-click the chart and choose “Save as Template…”.Insert a chart and change the formatting to prepare it for presentation.If you'd like to learn how to create that pivot table and chart, checkout my free videos series on pivot tables and dashboards for Excel. We can save all the formatting options and settings to a Chart Template, and then apply the template to any new or existing chart. My typical process to cleanup a Bar PivotChart includes a minimum of 7 steps and a total of 18+ mouse/key presses.įortunately, we can automate this process with Chart Templates. After inserting a chart on a sheet, we typically take additional steps to format it. Chart Templates to the RescueĮven if you don't follow these principles, it's likely that the default chart formatting doesn't match your needs. ![]() ![]() My good friend Mynda Treacy from MyOnlineTrainingHub also covers these principles in her Dashboards Course. To learn more about this topic checkout the books by Edward Tufte and Stephen Few (Amazon links). All the extra formatting is typically referred to as chart junk because it clutters up the chart and distracts the reader. The main idea is that we should use a minimalist approach to creating and designing charts (graphs). This makes the chart easier to read, and allows the data to tell the story.Įntire books have been written on the principles of data visualization, so I won't go into a lot of detail here. A nicely formatted chart should include only the minimal amount of elements (legend, axis, labels, gridlines, etc.). The default chart formatting in Excel typically includes a lot of extra elements that aren't always needed for our charts. Bottom line: Learn how to use Chart Templates in Excel to quickly apply formatting and settings to new and existing charts. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |