Excel Shortcut - Insert Chart

Learn Excel From MrExcel, Podcast Episode 2134: Continuing Our Favorite Keyboard Shortcuts.

If you need to quickly create a chart, just select the data and ALT+F1. Now, back in the day, this was F11 but that would create its own chart sheet, still creates its own chart sheet, but ALT+F1 creates this clustered column chart.

Now, what if your job is not to create clustered column charts? Well, then we'll go to the chart, we'll right-click and say CHANGE CHART TYPE, choose the chart type that you’d like to create, and maybe create bar charts or something like that, click OK and then we're going to save this as a template, SAVE AS TEMPLATE, and then I will call it PODCAST2134, like that, and then, the next time I have to create a chart, we’ll select the data, we'll go into INSERT, ALL CHARTS, go to TEMPLATES, and then find PODCAST2134, right there. We're going to right click and choose SET AS DEFAULT CHART. That is what we're going to get when we press ALT+F1.

So, the next time I have to create a chart, I just select the data, ALT+F1, and I will get the bar chart, and of course you can customize this as much as you want before you set the template.

Thanks for stopping by. We'll see you next time for another netcast from MrExcel.