Excel 2007 - two pie charts different colors but the same slices 1

[cjbrown815]

Hello,
I have two pie charts on the same worksheet side by side set to "very colors by slice, pulling the same data, the same labels. The only difference is one is averaging 2009 Jan, Feb, Mar hours and the other is averaging 2009 Aug, Sep, Oct hours. The slices are different colors as expected. However I need them to be the same color for each pie. For instance I have a slice of pie for both pies that is labeled Quality System, the Quality system slice is red on one pie and the other is blue. I need them both to be the same color for each identical slice. Is there an easy way to synchronize the colors of both pies without having to individually force each one of the peices?

thanks

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[SkipVought]

Hi,

This is a pretty simple thing to do manually.

Is this not a one-time "fix?"

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[cjbrown815]

It is, I was hoping for an easier tool other then having to match the two up and hand pick each segment and configure.

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931