How do i get integer number on th Yaxis of a chart

Discussion in 'Programming' started by fluiter, Nov 24, 2005.

0
  1. #1
    I'm realy desperate, so hopefully i can find the answer her.

    I'm trying to get an integer number on the Yaxis of a chart.
    What ever i've tried it always comes up with a tow decimal number instaed
    of an integer number.

    My code is as follows

    <cfset aYearAgosDate = DateAdd('m',-11,now())>
    <cfset end = now()>
    <cfquery name="EMEA" datasource="issue">
    SELECT count(region) as emeacount,
    month(date_issue) AS month, year(date_issue) AS year
    FROM tbl_issue
    WHERE tbl_issue.date_issue
    BETWEEN #aYearAgosDate# AND #end#
    ANd region='EMEA'
    GROUP BY year(date_issue),month(date_issue)
    </cfquery>
    <html>
    <head>
    <title>Global issues received.</title>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
    </head>

    <body>
    <cfchart showborder="yes" show3d="yes"
    chartheight="400" chartwidth="600" yaxistitle="number" xaxistitle="Month " seriesplacement="stacked" databackgroundcolor="##FFFFCC" backgroundcolor="##FFFFCC">
    <cfchartseries type="bar"
    query="EMEA"
    itemColumn="month"
    valueColumn="emeacount"
    seriesLabel="EMEA"/>
    </cfchart>
    <cfdump var="#EMEA#"/>
    </body>
     
    fluiter, Nov 24, 2005 IP