The only thing I cant change is the font thats actually IN the graph, Its not tied to fontsize= thats listed. Thats just for the itemcolum= and the valuecolum=. Anyone know enough CF to know how I might 1) change the font size in a grapgh or 2) rotat it 90 degrees???
<html>
<head>
<title>GARLAND FSC CAHT</title>
</head>
<body>
<p><br>
<cfquery name="GetCAHT" datasource="xga_caht">
SELECT CONVERT(INT, CAHT) AS CAHT ,750 AS OBJ, right(convert (varchar,dtstamp + 0.083333333),8) as TIME, convert(int,cw) as cw
FROM prod_15mincenterstats
WHERE (centerID = 6) AND (CONVERT(varchar, dtstamp, 112) = CONVERT(varchar, GETDATE(), 112)) AND (agent_group = 1)
ORDER BY dtstamp
</cfquery>
<cfquery name="GetCAHT2" datasource="xga_caht">
SELECT left((CAHT /60 ),5) as caht_time, left(caht,3) as CAHT
FROM prod_15mincenterstats
WHERE (centerID = 6) AND (CONVERT(varchar, dtstamp, 112) = CONVERT(varchar, GETDATE(), 112)) AND (agent_group = 1)
and dtstamp = (select max(dtstamp) from prod_15mincenterstats where (centerID = 6) AND (CONVERT(varchar, dtstamp, 112) = CONVERT(varchar, GETDATE(), 112)) AND (agent_group = 1))
--group by max(right(convert (varchar,dtstamp + 0.083333333),8))
</cfquery>
<cfoutput query="GetCAHT2"><strong>Daily CAHT #caht# seconds or #caht_time# minutes</strong></cfoutput> </p>
<p>
<cfchart format="flash"
TITLE = "GARLAND CAHT "
backgroundcolor="##ffffff"
scaleTo = 900
scaleFrom = 600
showYGridlines = YES
fontSize = 10
labelFormat = NUMBER
showBorder = YES
chartHeight = 200
chartWidth = 800
tipbgcolor = yellow>
<cfchartseries type="pyramid"
seriescolor="99FF33"
markerstyle="circle"
paintstyle="shade"
query="getcaht"
datalabelstyle="value"
itemcolumn="TIME"
valuecolumn="CAHT">
</cfchartseries>
</cfchart>
</p>
</body>
</html>
The fonts that are circled in red below...
|
