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.

Worth $20, Absolutely Free

Change the Default Chart Type in Excel

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.

Steps to Change the Default Chart

  • Go to Insert Tab → Charts.
  • Click on the small arrow at the bottom right corner of the section to get the insert chart window.

  • Then in your insert chart window, Go to “All Charts” & then select chart category.

  • Now, go to the chart style which you want to make your default chart. Right click on it & select “Set As Default Chart”.

  • Click OK.

Now, every time when you Insert a Chart Using a Shortcut you will get your favorite chart type.

Conclusion

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.

Must Read: