Pie Chart plotting 1 single color for multiple data points

Hi all,

I'm having a very frustrating issue with 2007. So, I make a normal chart. I let it go with the default style 2. (The multi colors.) I change it to style 18 (adding the shadow). It works okay.

Then, I select a new data series 1 column over for the data point names, and 1 column over for the data points themselves. I press okay, and suddenly my pie chart, which was originally different colors, is now one single color! It's always the last color, too.

So, I change it back to style 2, and it looks fine! Back to style 18, and it does not. Any ideas??

Bug.

To get around the bug clear the cells that contain zero.