Pie Chart & Series

[AlanDI1]

I want to create a pie chart and based on an Assessment an item in the database will be marked as green, red or yellow. I always want the green items to appear as a green color in the pie chart, the red as red, etc. So I wrote a query and pass it a 'G', 'R' or 'Y' and it returns the correct items.

Here's the chart:

<cfchart format="flash" show3d="yes" pieslicestyle="solid"
url="ATOSMPAssessDetail.CFR?SelectCYCYMM=#MaxATOSMPCYCYMMRet.MaxATOCYCYMM#&amp;SelectAssess=$ITEMLABEL$&amp;SelectATOSMP=#URL.SelectATOSMP#" >
<cfchartseries type="pie" query="getCountGreenforOneATO_SMPCYCYMMRet" itemcolumn="ASSESSMENT"
valuecolumn="AssessCount" colorlist="##006600" />
<cfchartseries type="pie" query="getCountRedforOneATO_SMPCYCYMMRet" itemcolumn="ASSESSMENT"
valuecolumn="AssessCount" colorlist="##CC0000" />
<cfchartseries type="pie" query="getCountYellowforOneATO_SMPCYCYMMRet" itemcolumn="ASSESSMENT"
valuecolumn="AssessCount" colorlist="##FFFF00" />
</cfchart>

If I make this a bar chart, I see the Greens, the Reds and the Yellows assuming they exist. But the minute I make it a pie chart all I see is the first series, the greens.

What have I missed?

Thanks