Highlighted

cfchart yaxis scale is wrong when combining bar and line charts

Community Beginner ,
Oct 14, 2014

Copy link to clipboard

Copied

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>

TOPICS
Reporting

Views

601

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

cfchart yaxis scale is wrong when combining bar and line charts

Community Beginner ,
Oct 14, 2014

Copy link to clipboard

Copied

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>

TOPICS
Reporting

Views

602

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Oct 14, 2014 0

Have something to add?

Join the conversation