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.