Neverguesswho Report post Posted July 3, 2012 Hi, I have been able to create/render my chart fine. My only problem is that I can't figure out a way to add hover text to the points that aren't already labeled on the x axis. I was able to do this before with xml but I am trying the asp Class format now. Here is my code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <%@ Language=VBScript %> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title></title> <link href="../assets/ui/css/style.css" rel="stylesheet" type="text/css" /> <script type="text/javascript" src="jquery.min.js"></script> <style type="text/css"> body,html,head,div{height:100%; min-height:100%;width:100%; } </style> <script LANGUAGE="Javascript" SRC="FusionCharts.js"></SCRIPT> </head> <!-- #INCLUDE FILE="FusionCharts.asp" --> <!-- #INCLUDE File="NewArray.asp" --> <!-- #INCLUDE File="DBConn2.asp" --> <!-- #INCLUDE File="RaceandColor.asp" --> <!-- #INCLUDE File="FC_Colors.asp" --> <!--#include file="FusionCharts_Gen.asp"--> <!-- #include virtual="nett/header.asp" --> <body > <div class="gen-chart-render" > <% Dim strValue,strCategory, count, lc, hWeek,lWeek,month,year,cateCount,today, diffDate,sum,syear,ors2,monthsA(6), monthsB(3),x, isInA,isInB dim FC monthsA(0)=1 monthsA(1)=3 monthsA(2)=5 monthsA(3)=7 monthsA(4)=8 monthsA(5)=10 monthsA(6)=12 monthsB(0)=4 monthsB(1)=6 monthsB(2)=9 monthsB(3)=11 set FC = new FusionCharts Call FC.setChartType("Line") Call FC.setSize("90%","90%") call FC.setSWFPath("../testfiles/") Call FC.setID("NewChart") lc=0 Set oConn = Server.CreateObject("ADODB.Connection") Set oRs = Server.CreateObject("ADODB.Recordset") Set oRs2 = Server.CreateObject("ADODB.Recordset") oConn.Open strConnQuery today=Date() year=2010 hWeek=31 lWeek=01 month=05 syear=2011 cateCount=0 count = 1 endDate=month&"/"&hWeek&"/"&year do While DateDiff("d",CDate(endDate),today)>7 do While month<=12 And DateDiff("d",CDate(endDate),today)>40 diffDate = DateDiff("d",CDate(endDate),today) x=0 isInA=false isInB=false do while x <= 6 and isInA = false if monthsA(x) = month then isInA = true 'response.Write(monthsA(x)) 'response.Write("/br") end if x=x+1 loop x=0 do while x <= 3 and isInB = false if monthsB(x)=month then 'response.Write("arrayB") isInB = true ' response.Write(monthsB(x)) end if x=x+1 loop 'Starting new method for linegraph sum = 0 if isInA then hWeek=31 'response.Write("work") strQuery = "select sum(zStratumID) as TotOutput from zRandomizationCode where zRandomizedOn BETWEEN '"&year&"-"&month&"-"&lweek&"' AND '"&year&"-"&month&"-"&hweek&"' " Set oRs = oConn.Execute(strQuery) sum = oRs("TotOutput") If month =1 then response.write("1st quarter") Call FC.addChartData("" & sum & "","label = 1st Quarter of "&year&"","") Elseif month =10 then response.write("4th quarter") Call FC.addChartData("" & sum & "","label = 4th Quarter of "&year&"","") elseif month = 7 then response.write("3rd quarter") Call FC.addChartData("" & sum & "","label = 3rd Quarter of "&year&"","") Else Call FC.AddchartData(""∑&"","","") End if end if If isInB then ' response.Write("nope") hWeek=30 strQuery = "select sum(zStratumID) as TotOutput from zRandomizationCode where zRandomizedOn BETWEEN '"&year&"-"&month&"-"&lweek&"' AND '"&year&"-"&month&"-"&hweek&"' " Set oRs = oConn.Execute(strQuery) sum = oRs("TotOutput") if month = 4 then response.write("2nd quarter") Call FC.addChartData("" & sum & "","label = 2nd Quarter of "&year&";hoverText=qwe;","") else Call FC.addChartData("" & sum & "","HoverText=qwe","") end if end if if isInA = false and isInB=false then 'for leapyear can use % of year hWeek=28 strQuery = "select sum(zStratumID) as TotOutput from zRandomizationCode where zRandomizedOn BETWEEN '"&year&"-"&month&"-"&lweek&"' AND '"&year&"-"&month&"-"&hweek&"' " Set oRs = oConn.Execute(strQuery) sum = oRs("TotOutput") Call FC.addChartData("" & sum & "","","") end if month = month + 1 loop month = 1 year=year+1 endDate=month&"/"&hWeek&"/"&year Loop strparam=" caption=Quarterly Enrollment; subcaption=Current; xAxisName=Months; yAxisName=# of People; hovercapbg=FFECAA; hovercapborder=F47E00; formatNumberScale='0'; decimalPrecision='0'; showvalues=0; numdivlines=5; numVdivlines=6; yaxisminvalue='0'; lineThickness=2; rotateNames='1'; baseFontSize='15'; animation=0; shadow =0; alpha=0; anchorAlpha='0';showshadow=0; anchorRadius = 2;hoverText=1;" call FC.setChartParams(strparam) Call FC.addTrendLine("startValue=50;endValue=50;color=FF0000;displayvalue=Target Enrollment;thickness=2;alpha=100;isTrendZone=0;showOnTop=1") call FC.SetRenderer( "javascript" ) call FC.renderChart(false) Set oRs = Nothing oConn.close %> </div> </body> </html> and here is a picture of my chart. Share this post Link to post Share on other sites
Guest Sumedh Report post Posted July 4, 2012 Hi, For custom tool-tip you would need to add toolText attribute in the set element. You would need to add following line code into your project to have custom tool-tip on the data-plots. Ref. code: Fc.addChartData("32","label=Week 1","toolText=myTooltext") Share this post Link to post Share on other sites
Neverguesswho Report post Posted July 5, 2012 (edited) On 7/4/2012 at 12:48 PM, Sumedh said: Hi, For custom tool-tip you would need to add toolText attribute in the set element. You would need to add following line code into your project to have custom tool-tip on the data-plots. Ref. code: Fc.addChartData("32","label=Week 1","toolText=myTooltext") Great thanks so much!!!! Edited July 5, 2012 by Neverguesswho Share this post Link to post Share on other sites
Guest Sumedh Report post Posted July 6, 2012 On 7/5/2012 at 4:59 PM, Neverguesswho said: Great thanks so much!!!! Share this post Link to post Share on other sites
