Pie Chart Slice Colors

I have pie charts on separate tabs of a spreadsheet. I manipulate the data to take out any series with no data (value of 0). Unfortunately, when I compare graphs, the same series is not color consistent across all graphs. How can I ensure that any series will have the same color on every graph? The data sets are independent for each tab.

Hi,

I guess you would need a macro for this, Please go through the following URL for more details.

http://windowssecrets.com/forums/sho...s-(Excel-2000)