Hello,

I am dealing with a document that holds multiple bar graphs with several columns in each chart. After changing to 2007 from 2003 I must change the colors of and gradient of each bar. Because the color of each column is conditional on the percentage it holds, I cannot simply change the color and formatting of each graph as a whole. I would like to know if it is possible for me to apply some sort of format painter to the bars so I do not have to manually change the color and gradient of each bar in every single graph. If not, is there any other solution to save me time?

Thanks!