Right-click one of the chart sub-types, such as Line, and click on Set As Default Chart.Click the All Charts tab, and click one of the chart categories, such as Line.On the Ribbon’s Insert tab, click the See All Charts button, at the bottom right of the Charts group.If you’d like a different chart type as the default, you can easily change it. If you select data and press the F11 key, that’s the type of chart that will be created. When you first install Excel, the default chart type is a clustered column. Change the Default Chart TypeĪnd now, here is a chart tip, for those times when you’re creating a simple chart. You’ll have 24 hours to reply to his email.
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:Ĭongratulations, and Jon will send you an email to arrange the delivery of your Chart Utility.