formatting data series
 

Hello, I have Excel 2007.

I have a stacked bar chart comprising 4 data 'series' . I want to change the
formats of the bars.

I know how to select a series & format it, but can I format all 4 series
simultaneously , or can I format one and copy that format to the others (I
only want the bar colours to be different)

Thanks

KK