Скачать или смотреть Excel - Customize and Save Chart Formatting in Excel | Time-Saving Tip! - Episode 372

Microsoft Excel Tutorial: Customize and Save Chart Formatting in Excel | Time-Saving Tip!

Welcome to another episode of the MrExcel netcast! In this video, we'll be discussing a handy tip for customizing charts in Excel. During one of my recent power Excel seminars, a participant asked how they could apply their customized chart formatting to all future charts. And that's exactly what we'll be covering today.

Usually, when customizing charts, we right-click around the chart to make it look just the way we want. But what if we want to save that formatting for future use? Well, it's actually quite simple. First, select the chart and go to the Charting menu. Then, choose Chart Type and go to the Custom Types tab. From there, click on User-defined and then click the Add button. Give your chart a name, such as "MyChart", and click OK.

But here's the best part - you can even set this chart as the default for all future charts. Just click on the button that says "Set as default chart", click Yes, and then click OK. Now, whenever you have new data and want to create a chart, simply select the data and hit the F11 key. Excel will automatically create a new chart with all of the formatting from your saved chart. This is a great time-saving tip, especially if you need to create charts in company colors or with a specific style.

Thanks for tuning in to this episode of the MrExcel netcast. I hope you found this tip helpful and will be able to use it in your own Excel projects. Don't forget to subscribe to our channel for more Excel tips and tricks, and we'll see you next time for another netcast from MrExcel!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...


Table of Contents:
(00:00) Charting question from seminar
(00:14) Customizing charts with right-click
(00:24) Applying formatting to future charts
(00:34) Using Charting menu and Custom Types tab
(00:45) Adding a new chart type
(00:55) Setting as default chart
(01:05) Creating new charts with F11 key
(01:15) Saving time with company colors
(01:25) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Adding user-defined chart types in Excel
Applying formatting to future charts
Creating charts with company colors in Excel
Creating charts with saved formatting
Customizing charts in Excel
Excel charting tips and tricks
Excel power Excel seminar tip
MrExcel netcast tutorial
Saving time with chart formatting in Excel
Setting default chart in Excel
Using the F11 key to create charts in Excel
YouTube charting tutorial


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...


Once you have customized a chart, add the chart to your library of user defined charts. You can then apply all of that chart formatting to a new chart with a single keystroke! Episode 372 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!