Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
10000+ Copies Already Downloaded
Do you know you can insert a chart with a shortcuts key?
You can use Alt + F1 to insert a chart.
But here’s a twist.
In Excel, default chart type is a two-dimensional column chart. So, if you want to insert a line chart or any other chart which you use frequently with a shortcut key, you can’t do that.
So, here using a shortcut key is for nothing.
But, I have a solution for that.
You can change the default chart type. So that when you use a shortcut key to insert a chart you will get the same chart that you required.
Now, every time when you Insert a Chart Using a Shortcut you will get your favorite chart type.
By changing default chart type, you will able to create your most used chart with a shortcut key. Let’s say if you use line chart more than any other chart you can make it your default chart. And, then you can use the shortcut key.
I hope you will like this, please share you most used chart types in the comment box.