CFCHART and CFQUERY problem :(
Hi,
I'm trying to use <cfchart> to create a pie chart from a query that shows 3 wedges with 3 different values. I can't for the life of me figure out how to do this. Here is my code:
<cfchart format="png" chartheight="150" chartwidth="200">
<cfchartseries type="pie" query="qCompanyStatus">
</cfchart>
The query returns 1 row with 4 columns
CompanyName | NumberStarted | NumberInProgress | NumberComplete
ABC Company, 4, 5, 9
I'd like to display a pie chart with three wedges showing the values in each of these columns.
How can I do this? It seems there is only an itemcolumn and valuecolumn, I need to display multiple values here and just not sure how to do it. It must be something simple.
Any help highly appreciated...
Thanks
