Thanks - this is perfect! -Joanne

This e-mail may contain information protected under the Family Educational Rights and Privacy Act (FERPA).  If this e-mail contains student information and you are not entitled to access such information under FERPA, please notify the sender.  Federal regulations require that you destroy this e-mail without reviewing it and you may not forward it to anyone.

>>> Clint Hepner <[log in to unmask]> 12/7/2007 10:30 AM >>>
I think this will do what you want. Make the first chart the way you like, then (with that chart selected), choose "Chart Type" from the "Chart" menu. Click on the "Custom Types" tab, and select "User-defined" radio button at the bottom of the tab. An "Add..." button will appear, allowing you to save your current chart's format as a new custom chart type. For each of the other charts, just choose your new chart type from the "Custom Types" tab rather than one of the built-in chart types. Different patterns for the data series should be saved, as well as any titles and axis labels you set.
 
Clint Hepner
South Royalton School
223 South Windsor Street
South Royalton, VT 03755
(802) 763-7740

________________________________

From: School Information Technology Discussion on behalf of Joanne Finnegan
Sent: Thu 12/6/2007 3:36 PM
To: [log in to unmask] 
Subject: Excel Question - charts



Does anyone know if there is a way to set the default colors for charts in Excel 2003 so that some of the colors are patterns rather than colors?  We are trying to create several charts for a presentation that will be copied in B&W and need 5 distinct patterns for sections on pie charts.  I do know that I can do each individually, but there are about 50 charts, with 3 - 5 sections on each chart - very tedious to do each one separately!




This e-mail may contain information protected under the Family Educational Rights and Privacy Act (FERPA).  If this e-mail contains student information and you are not entitled to access such information under FERPA, please notify the sender.  Federal regulations require that you destroy this e-mail without reviewing it and you may not forward it to anyone.