I have created a dynamic bar chart based on what the user selects (Species ) on
form. I have trouble when the user select more than one species to chart. The
chart that is produced when they select more than one species is for the last
species they selected from the list. I would like all the species they select
to be represented.

What I would like:

x axis - bird count
y axis - year
stacked bar representing count for each year for all species selected.

My current code on the action page:

<cfquery name="MakeBarChart" datasource="bsc">
Select *
From Calculated
Where SiteCode IN (#ListQualify(form.SiteCode, "'", ",", "All")#)
And Speciesdesc IN (#ListQualify(form.SpeciesDesc, "'", ",", "All")#)
order by BirdYear
</cfquery>


<CFCHART
FORMAT="flash"
SHOWYGRIDLINES="yes"
xAxisTitle="Year"
yAxisTitle="Count"
SCALETO="13"
SCALEFROM="1"
SHOW3D="yes"
GRIDLINES="5">

<cfchartseries
type="bar"
query="MakeBarChart"
valueColumn="TotalperSpecies"
itemColumn="BirdYear">
</CFCHART>