Okay, I'm having a difficult time putting this into words, so please bear with me. Normally, when you have a line pivotchart with nested series, all the series are different colors/markers. This makes it easy to distinguish individual series in the chart. However, sometimes I'm more interested in the spread of the individual series in the parent fields. In other words, I'd rather have all the series in the each parent field the same color.

For instance, say I had a dataset detailing the number of widgets sold by day for six people, 3 women and 3 men. I create a pivotchart with the days on the x-axis, the # widgets on the y-axis, and then the gender and names in the Legend fields (series). The names are nested in the gender. Each of the six lines are now different colors. However, I'd like all of the 'male' lines to be one color, and the 'female' lines to be another color. (This is a totally made up example, btw.)
Is there a way to do this automatically?
I just upgraded to excel 2007 and was manipulating a Pivotchart with my data and after doing a pivot, noticed that this happened. I don't know if it was a glitch or not, because I haven't been able to replicate it.

Any help would be greatly appreciated.

Thanks!
d