• Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • More
    • Blog
    • Download Area
    • Excel Video Tutorials
You are here: Home / Blog / Change The Default Chart Type In Excel

Change The Default Chart Type In Excel

October 18, 2013 by Barbara —Leave a Comment

When Excel is installed the default chart is a clustered column chart, so if you hit F11 for a quick chart then that is the type of chart that is created.

If you do not often use a clustered column chart that often, then you can change the default type that Excel creates. In Excel 2010 it’s done in a few steps….

 

  • Create a chart as normal.
  • Select Change Chart Type from Design Tab in Chart Tools.
  • Select the type of chart you prefer to be your default type.
  • Click Set As Default Chart button.

…and that is it. Easy. Now when you go to create a super quick chart excel will choose the YOUR chart type specified.

set default chart

 

More Excel Tips

 

 

1. Create dynamic titles in Excel charts

2. Quickie Excel Tip :Change your chart type

3. Make all of your Excel charts the same size

 

Free Ebook???- 30 Charting Tips For Excel

Just click below for your FREE Book.

images-15

 

 

 

 

 

 

Filed Under: Blog, Excel Charting Tagged With: Excel, Excel Charting

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Share
Tweet
Additional Info

Follow How To Excel At Excel

   

Need Answers To Excel Questions Like These?

*How Do I Create A Timestamp In Excel?
*I Want To Change The Width Of The bars On My Excel Chart
*How Can I Find Out The Length Of My Text in Excel? Click the link below to receive more Excel tips' and my Free Ebook

Sign Up For My FREE Excel Tips Newsletter and receive your own E-book of my Top 50 Excel Tips.

New To Excel? This Is A Great Place To Start!!

excel-formulas-ad-5 Excel Basics
Scrollbars
Colour of Sheet Tabs
Conditional Formatting
Calculations Introduction

Advanced Excel

Power BI Webinar Excel Expert Course Excel Dashboard Course
Data Validation Lists
Create A Timestamp
Create Table Of Contents

Excel Charting

Self Expanding Charts
One Click Charts
Create Quick Dynamic Charts
Easy Combination Charts

Video Tutorials-If You Like To Learn By Watching

Subscribe to YouTube to get notified of of new Excel videos.


Self Expanding Chart
Delete Obsolete Items From A Pivot Table-Excel 2007
What Are Pivot Tables- Create Your First One
Enable The DeveloperTab In Excel

Some Fun Stuff

Pivot Table Song


Tags

Blog Cells Excel Excel Charting Excel Formulas excel tip Excel Tip Category Excel Tips Excel Tips& Tricks excel tutorials Excel Videos Excel Video Tutorials formatting Formula formula friday Formulas macro Macro Mondays Macros Pivot Tables Power BI Power Query Tutorials vb VBA Worksheets

Follow How To Excel At Excel

   

Recommended Excel Resources

Free Excel Dashboard Webinar

Copyright © 2018 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in


  • Privacy Policy