2 Replies Latest reply on Feb 1, 2012 8:42 AM by WestSide

    CFCHART and CFQUERY problem :(

    WestSide Level 1



      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">



      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...