0 Replies Latest reply: Oct 14, 2014 8:46 AM by sherrimc99 RSS

    cfchart yaxis scale is wrong when combining bar and line charts

    sherrimc99 Community Member

      Hi, I am trying to combine a bar and line chart ti display data.  Everything looks good except that the yaxis scale is off.  I set the scaleMin to 0 but that doesn't help.  Below is my code, the custom XML style and a screen shot.  My ultimate goal is to get the yaxis to start at 0, not -1,000 as is currently the case.  I have combined this data with each set represented as bar charts and do not have this problem.  It must be the combo of bar and line charts together.  Any assistance is most appreciated.

       

       

      <cfchart title = "#variables.ReportName# Seedlings Ordered"

          style = "../SO_R_overall.xml"

          Format = "PNG"

          pieSliceStyle = "solid"

          show3D = "no"

          showBorder = "yes"

          showLegend = "yes"

          tipStyle = "MouseOver"

          chartHeight = "#DefinedChartHeight#"

           chartWidth = "#DefinedChartWidth#"

          font="arial"

          fontsize="12"

          fontBold="yes"

          scaleFrom="0">

       

          <cfchartseries

              type="bar"

              seriesLabel="Goal"

              query="getDivisionGoalsByDivision"

              valueColumn="divisiongoal" 

              itemColumn = "division"

              dataLabelStyle="Value"

              seriesColor="99CCFF"

              >           

          </cfchartseries>   

             

          <cfchartseries

              type="line"

              seriesLabel="Ordered"

              query="getQTYordered"

              valueColumn="QTYordered" 

              itemColumn = "division"

              dataLabelStyle="Value"

              seriesColor="green"

              >           

          </cfchartseries>

      </cfchart>

       

      ***************** Custom Chart Style called *****************

      <?xml version="1.0" encoding="UTF-8"?>

      <frameChart is3D="false">

              <frame xDepth="3" yDepth="3" outline="#333333" lightColor="white"

              leftAxisPlacement="Front" rightAxisPlacement="Front" stripColor="#CCCCCC"/>

              <xAxis scaleMin="0">

                  <labelStyle isHideOverlapped="false" orientation="Horizontal"/>

                  <titleStyle font="Arial-10-bold" isMultiline="true">Division</titleStyle>

              </xAxis>

              <yAxis scaleMin="0">

                  <titleStyle font="Arial-10-bold"/>

                  <dateTimeStyle majorUnit="Year" minorUnit="Month"/>

                  <labelFormat style="Pattern" pattern="#,##0"/>

              </yAxis>        

             

              <dataLabels font="Arial-10" foreground="black" autoControl="true"/>

              <legend>

                     <![CDATA[ $(rowLabel)  ]]>   

                </legend>

             

              <decoration style="RoundShadow"/>

              <popup background="#C8FFFFFF" foreground="#333333"/>

              <paint paint="Plain"/>

              <insets left="5" top="5" right="5" bottom="5"/>

      </frameChart>