Creating Default Charts in Excel 2007

Gosh..sorry.. I am really getting behind and it is only November.. December is not looking promising. Anyway, I wanted to spend some more time talking about charts particularly since there are a lot of changes between Excel 2003 and Excel 2007. You can still do almost everything that you could before -( the exception being using goal seek and charts)- it is just more steps and/or not as intuitive as before.

So let's start with some basics.
Today .. or tonight I want to talk about creating a default chart.

The default chart type for Microsoft Excel is a column chart. If you routinely create a different type of chart, such as a line chart, you can change the default chart type.
Create a default chart from an existing chart

• Open the file containing the chart you want to use
• Double-click on the chart
• On the Type group, select Change Chart Type
• Select the chart type you want to be the default.. i.e. a line chart
• Click Set as Default Chart (located at the bottom of the dialog box)
• Click OK
  
• Please note that only impacts the chart type- it does not change the colors or other formatting elements.

Tomorrow... hmm I think I am on vacation tomorrow... Okay on Monday we will discuss how to create custom charts containing colors, formatting etc that you want applied to all or most of your charts. Have a good weekend if I don't talk to you tomorrow.