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

    CFCHART and CFQUERY problem :(

    WestSide Level 1

      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