software

I am making a series of bar charts that use the same categories (i.e. school
name). The bar for each school needs to have a unique color, which will
remain the same in each chart. Also, the order in which the schools are
listed may vary from chart to chart. I assume a macro could be constructed
to perform this type of conditional formating? Any assistance would be
appreciated. Thanks.
This site helped me...
peltiertech.com/Excel/Charts/...nalChart1.html

quot;Scott Bucherquot; wrote:

gt; I am making a series of bar charts that use the same categories (i.e. school
gt; name). The bar for each school needs to have a unique color, which will
gt; remain the same in each chart. Also, the order in which the schools are
gt; listed may vary from chart to chart. I assume a macro could be constructed
gt; to perform this type of conditional formating? Any assistance would be
gt; appreciated. Thanks.
gt;
gt;