Also, does anyone know how to get Excel to apply multiple colors to charts automatically?