0 Replies Latest reply on Jan 11, 2013 10:50 AM by rockhiker

    cfchart - bar chart colors

    rockhiker Level 1

      I have the following bar chart that displays each bar in the same color. I cannot figure out how to change the colors since i use more than 1 query.

      Any ideas.?

      Thank you

       

      Jim

       

       

       

      <cfchart
               format="jpg"
               scalefrom="0"
               scaleto="150"
              
              showborder="yes"
              show3d="yes"
              fontbold="yes"
              backgroundcolor="##ffffff"
              fontSize="14"
              chartwidth="415"
               chartheight="310"
               title="Project Status">
            

       

      <cfchartseries
                    type="bar"
                    serieslabel="Active Project Status"
                    seriescolor="##517488">
                      
                      
                       <cfquery name="projectStatus" datasource="rolProjects">
      SELECT count(ProjectID) as con
      FROM dbo.v_cf_AllProjectList
      wHERE STATUS='aCTIVE'
      and ActiveContractStatus ='Construction'

      </cfquery>
                      
        <cfchartdata item="Construction" value="#projectStatus.con#">
             
         
              <cfquery name="projectStatus1" datasource="rolProjects">
      SELECT count(ProjectID) as ped
      FROM dbo.v_cf_AllProjectList
      wHERE STATUS='aCTIVE'
      and ActiveContractStatus ='PE and Design'

      </cfquery>
             
                 
             
             
          <cfchartdata item="Design" value="#projectStatus1.ped#">
             
        
       
              <cfquery name="props" datasource="rolProjects">
             
              SELECT count(*) as prop
              From dbo.v_cf_ProposedProjectList
              </cfquery>
             
           <cfchartdata item="Proposed" value="#props.prop#">
       
      </cfchartseries>
      </cfchart>