More than one value column in a cfchart?

[solaced]

I have a data table which displays data like this:

0-1	1-3	11-14	14-21	DEPT
3.77	0.94	3.46	11.95	SALES

So I have many columns for the 'valuecolumn', and only one column for the 'itemcolumn'. But it looks like in the tag it will only accept one 'valuecolumn' even though I have many. How would I make this work?

<cfchartseries type="bar"

query="stats"

valuecolumn="0-1"

itemcolumn="DEPT"

</cfchartseries>

As you can see I can't put multiple columns into the valuecolumn attribute

[BKBK]

solaced wrote:

valuecolumn="0-1"

It should be a column name, something like

valuecolumn="sales"

[Dan_Bracuk]

Use a separate chartseries tag for each field you want to graph.