Can anyone tell me if there is a way to create a macro/add-in that will change the colors of a selected chart (pie, bar, whatever it is) to a pre-defined series of colors? I have a specific set of colors that are used for all charts, and are in a certain order.. for example, red is always the first pie slice, or first bar (clockwise for pies, bottom to top for bars), then comes blue, etc..
Anything out there currently that will allow me to do this, or is it easy enough to create?
Thanks.