Change the Default Chart Type in Excel

On July 25th I announced a giveaway for Jon Peltier’s amazing Chart Utility, and thanks for all the entries! The deadline was yesterday, August 5th, at 12 noon Eastern time, and the winner of the random draw is:

Congratulations, and Jon will send you an email to arrange the delivery of your Chart Utility. You’ll have 24 hours to reply to his email.

Chart Utility Discount

If you didn’t win the giveaway, Jon has provided a coupon code that you can use to buy the Chart Utility at a 15% discount.

  • Click this link to go to the order page
  • Click the Add to Cart button, then enter the coupon code 55Ec9QGz in the order window.
  • The coupon will expire at 11:59:59 pm Eastern time, on Wednesday, 21 August, 2013.

Change the Default Chart Type

And now, here is a chart tip, for those times when you’re creating a simple chart.

When you first install Excel, the default chart type is a clustered column. If you select data and press the F11 key, that’s the type of chart that will be created.


If you’d like a different chart type as the default, you can easily change it. Here are the steps in Excel 2013:

  • On the Ribbon’s Insert tab, click the See All Charts button, at the bottom right of the Charts group.


  • Click the All Charts tab, and click one of the chart categories, such as Line.
  • Right-click one of the chart sub-types, such as Line, and click on Set As Default Chart


  • Click Cancel, to close the Insert Chart window.

In Excel 2010, the steps are almost the same – just click the Set as Default Chart button after you select a chart sub-type.


Watch the Video

To see the steps for creating a quick chart, and changing the default chart type in Excel 2010, please watch this short video.