ktsha

Hello, Is it possible to implement logos as labels inside column3D charts? Thanks.

Thanks a lot, it works.

Thanks for your reply, Please find attached the XML i am using for this, Thanks Sample.txt

Thanks, But this is not working for me. Its says "Invalid Xml Data" Should i need any other modifications other than the XML.

Thanks Sanjukta, This is exactly what i am looking for. Could you tell me how we can do this . Thanks for your prompt response and support.

Dear All, I have a Single Series Column 3D Fusion Chart,The XML is attached . In the chart i am having arabic labels. In my XML once i removed labelDisplay='Rotate' slantLabels='1' the arabic labels are displaying. But once i add this arabic labels are not displaying.:w00t: When i check the documentation i found,labelDisplay wont be applicable for languages other than English. I need my labels to be either in 45 degree or 90 degree. Your help will be appreciated, Thanks Column3D-Label-Display.txt

Thanks for your reply, I had done this response.setContentType("text/xml; charset=UTF-8"); String xmlChart = "My XML HERE" ServletOutputStream str = response.getOutputStream(); str.write(new byte[]{(byte)0xEF, (byte)0xBB, (byte)0xBF}); str.write(xmlChart.getBytes()); str.flush(); But Still i am getting ???? kind of values. Need your help,

Dear All, Had a problem with Column 3D Label Display, Here my labels are in Arabic Language. But when i changed to English,its working. Can any one give me any suggestions to solve this.. Column3D-Label-Display.txt

Thanks for your reply, I am usuing Java as my Scripting language.. me too awaiting your reply...

Dear All, Had a problem with Column 3D Label Display, Here my labels are in Arabic Language. But when i changed to English,its working. Can any one give me any suggestions to solve this.. <?xml version='1.0' encoding='UTF-8'?> bgAlpha='40,100' bgRatio='0,100' bgAngle='270' showBorder='1' borderColor='8C489F' labelDisplay='Rotate' slantLabels='1' showvalues='0'>Column3D-Label-Display.txt

Thanks for your reply I tried this response.setContentType( "text/xml; charset=UTF-8" ); OutputStream outs = response.getOutputStream(); outs.write( new byte[]{(byte)0xEF, (byte)0xBB, (byte)0xBF} ); outs.flush(); String xmlChart = "Here is my xml String" outs.write(xmlChart.getBytes()); I am getting a value like ???????? Not an Arabic text ... Could you please tell me what may be the reason??? Thanks

Dear all, I had created a fusion chart of StackedBar3D .I am successfull in getting the fusion chart. Now i am trying to implement a Drill down chart by caling a javascript function. My codes are like written below StringWriter chartXML = new StringWriter(); XMLStreamWriter2 xStreamWriter2 = (XMLStreamWriter2) xOutputFactory.createXMLStreamWriter(chartXML); xStreamWriter2.writeStartDocument(); xStreamWriter2.writeStartElement("chart"); xStreamWriter2.writeStartElement("categories"); for (Map map : resultList) { xStreamWriter2.writeStartElement("category"); xStreamWriter2.writeAttribute("label", (String) map.get("status_name")); // label names are displaying successfully //for implementing drill down chart from the documentation i found using the link attribute and calling the javascript function. According to documentation i written like this where updateFusionChart is the Javascript function. xStreamWriter2.("link","j-updateFusionChart-""+newCondQuery+"","" +FuncName+"",""+status_name+"",""+DrillDownKPI+"""); //xStreamWriter2.writeAttribute("link","javaScript:updateFusionChart(""+newCondQuery+"","" +FuncName+"",""+(String)map.get("status_name")+"",""+DrillDownKPI+"" )"); xStreamWriter2.writeEndElement();// category } xStreamWriter2.writeEndElement(); // categories I am trying to implement a Stacked Column 3D chart and i am successfull in generating it. When i pointed my mouse curson on the generated chart even the link cursor is also not displaying.I am facing the problem of link. Is there any problem with my link attribute and the javascript calling method. i tried with the two ways of calling javascript function.The second one is commented in the code I am a premium customer of Fusion Chart. Currently i am using Fusion chart version 3.1. Please Help me ....

Dear All, I got a doubt,Please clear it. This is the current Code below code is in XML LinkStr = "' link='javaScript:updateChart( "" + FuncName + "","" + (String) map.get("status_name") + "","" + DrillDownKPI + "")' />"; and this is the updateChart javascript function (XMLchart.js) function updateChart(Mngmnt,stutus,kpi,serviceID) { var strURL = "ChartServlet?GM=" + Mngmnt + "&status=" +stutus + "&kpi=" +kpi; strURL = escape(strURL); var chart_CityDetails = new FusionCharts('FusionCharts/StackedBar3D.swf?ChartNoDataText=Click right chart to view Services Details', 'ServDetails', '550', '450', '0', '1'); chart_CityDetails.setDataURL(strURL); chart_CityDetails.render(Mngmnt+kpi+"ServDetailsDiv"); } I want to pass a new parameter 'condQuery ' query with the link in XML i tried this LinkStr = "' link='javaScript:updateFusionChart( "" + condQuery + "","" + FuncName + "","" + (String) map.get("status_name") + "","" + DrillDownKPI + "")' />"; and updated javascript function as function updateChart (condQuery,Mngmnt,stutus,kpi,serviceID){ var strURL = "ChartServlet?GM=" + Mngmnt + "&status=" +stutus + "&kpi=" +kpi+ "&condQuery=" +condQuery; strURL = escape(strURL); var chart_CityDetails = new FusionCharts('FusionCharts/StackedBar3D.swf?ChartNoDataText=Click right chart to view Services Details', 'ServDetails', '550', '450', '0', '1'); chart_CityDetails.setDataURL(strURL); chart_CityDetails.render(Mngmnt+kpi+"ServDetailsDiv"); } But after execution it was showing as Invalid XML Data. Is there any problem with the parameter passing ?? Any help will be appreciated...

Hi all, How to place target value inside the plot. Currently it is displaying as a tooltip .I want to display as a text inside the plot. For example see the attached file,where "21514" is displayed . Thanks and Regards. att.bmp

Thanks a lot, But this was not up to the mark for my request . As annotation values will be in a static position eventhough my target plot goes increases. ie,Eventhough my target plot is nearer to Max value ,Annotation will be in the same position described previously . Do you have any solution for this :cool:

Hi, I tried using annotation Text . I am unable to view the text as it is hidden by the plot. If the annotation text is outside the plot i can view this. If i am adjusting according to my requirement(see the figure attached in my first query) it is not viewable. Please find my attached XML file . Please help me to solve this . Any help will be appreciated. xml1.txt

Hi, I am using Fusion Widget's Bullet Graph in my application . I have multiple bullet graphs . I want to change the color of the bullet graph to a desired one . ie the Colour of the Outer and inner bars . Please find attached of a sample H-Bullet graph. How to do this Any help will be appreciated.... bullet-graph.bmp

Thanks a lot . But in your documentation why it is written as color instead of code.

Hi, Please find my xml attached . xml11.txt

Thanks for the quick response. Plot Fill color and Pallete theme colour is working fine . But i am unable to change the colour part which is "8C489F" in my attached picture. Currently this part is default grey color . I want to change that colour too ... How to do this .... Thanks in advanced .....

Dear all, By Default from documentation it tells like FOR TOOLTIP "By default, FusionCharts shows the series Name, Category Name and value as tool tip text for that data item.". But for me its displaying catagory name and value. Series Name is not displaying . How to dispaly the series name, catagory label name , and value on a fusion chart ,Stacked column 3D bar as a Tool tip , when i pointed my mouse on it . Currently it is displaying only label and value.I want to display the series name as well.. Below attached is my XML xml.txt

Hi all, there is another query, In Fusion chart Documentation its written as My javascript function is under a public folder ,ie under public i have a 'js' package, under than my Chart.js , inside there is my function named updateFusionChart(......); When i tried to run the application ie, by click on the fusionchart to call the javascript function i was getting an error So how can i give the exact path for the javascript function. My currentlink attribute is given below. xStreamWriter2.writeAttribute("link","j-updateFusionChart(""+newCondQuery+"",""+funcNameList.get(k)+"","" +statusNameList.get(k)+"",""+DrillDownKPI+"")");

Dear all, Some body please help me to solve this issue. I am facing a fusion chart Drill down problem. i was trying to create a drill down chart. Please find my attached files.(java file and javascript files) private String getStack2D_Request_XML1(HttpServletRequest request,String condQuery,boolean forDataURL, String kpi, String L1, String L2, String L3, String condtion, boolean links, String DrillDownKPI) { SqlMapClient sqlMapClient = (SqlMapClient) getServletContext().getAttribute("sqlMapClient"); Map sqlParams = new HashMap(); String FuncName; List> resultList = null; sqlParams.put("whereCase",condQuery); sqlParams.put("whereCase_ServProvider",condtion); StringWriter chartXML = new StringWriter(); try { resultList = (List>) sqlMapClient.queryForList(kpi, sqlParams); XMLOutputFactory xOutputFactory = XMLOutputFactory.newInstance(); XMLStreamWriter2 xStreamWriter2 = (XMLStreamWriter2) xOutputFactory.createXMLStreamWriter(chartXML); xStreamWriter2.writeStartDocument(); xStreamWriter2.writeStartElement("chart"); if(resultList.size() >=1 ){ xStreamWriter2.writeAttribute("palette", "2"); xStreamWriter2.writeAttribute("showValues", "0"); xStreamWriter2.writeAttribute("animation", "1"); xStreamWriter2.writeAttribute("formatNumberScale", "0"); xStreamWriter2.writeStartElement("categories"); int start = 0; List funcNameList = new ArrayList(); List statusNameList = new ArrayList(); for (Map map : resultList) { FuncName = (String) map.get("func_name");// Human Resources, if (FuncName != null) FuncName = FuncName.replaceAll("&", "And"); else FuncName = "ALL"; funcNameList.add(FuncName); String status_name = (String) map.get("status_name"); statusNameList.add(status_name); xStreamWriter2.writeStartElement("category"); xStreamWriter2.writeAttribute("label", (String) map.get("status_name")); xStreamWriter2.writeEndElement();// category } xStreamWriter2.writeEndElement(); // categories int i,k ; Object[] series = (Object[]) resultList.get(0).keySet().toArray(); for (int j = 2; j < series.length-1; j++) { xStreamWriter2.writeStartElement("dataset"); xStreamWriter2.writeAttribute("seriesName", (String) series[j]); for (i = start,k = 0; i < resultList.size(); i++,k++) { Object[] record = (Object[]) resultList.get(i).values().toArray(); xStreamWriter2.writeStartElement("set"); String newCondQuery = URLEncoder.encode(condQuery); xStreamWriter2.writeAttribute("value", "" + record[j]); /*xStreamWriter2.writeAttribute("link","j-updateFusionChart(""+newCondQuery+"",""+funcNameList.get(k)+"",""+statusNameList.get(k)+"",""+DrillDownKPI+"");");*/ xStreamWriter2.writeAttribute("link","JavaScript:updateFusionChart(""+newCondQuery+"",""+funcNameList.get(k)+"",""+statusNameList.get(k)+"",""+DrillDownKPI+"" );"); xStreamWriter2.writeEndElement(); // set } xStreamWriter2.writeEndElement(); // dataset } xStreamWriter2.writeStartElement("styles"); xStreamWriter2.writeStartElement("definition"); xStreamWriter2.writeStartElement("style"); xStreamWriter2.writeAttribute("name", "CaptionFont"); xStreamWriter2.writeAttribute("type", "font"); xStreamWriter2.writeAttribute("size", "11"); xStreamWriter2.writeAttribute("bold", "1"); xStreamWriter2.writeAttribute("color", "666666"); xStreamWriter2.writeEndElement(); // style xStreamWriter2.writeStartElement("style"); xStreamWriter2.writeAttribute("name", "LabelsFont"); xStreamWriter2.writeAttribute("type", "font"); xStreamWriter2.writeAttribute("size", "11"); xStreamWriter2.writeAttribute("bold", "1"); xStreamWriter2.writeEndElement(); // style xStreamWriter2.writeEndElement(); // definition xStreamWriter2.writeStartElement("application"); xStreamWriter2.writeStartElement("apply"); xStreamWriter2.writeAttribute("toObject", "CAPTION"); xStreamWriter2.writeAttribute("styles", "CaptionFont"); xStreamWriter2.writeEndElement(); // apply xStreamWriter2.writeStartElement("apply"); xStreamWriter2.writeAttribute("toObject", "DataLabels"); xStreamWriter2.writeAttribute("styles", "LabelsFont"); xStreamWriter2.writeEndElement(); // apply xStreamWriter2.writeEndElement(); // application xStreamWriter2.writeEndElement(); // styles } xStreamWriter2.writeEndElement(); // chart xStreamWriter2.writeEndDocument(); xStreamWriter2.flush(); xStreamWriter2.close(); } catch (Exception e) { System.out.println("Exception occurred" + e.toString()); e.printStackTrace(); } return chartXML.toString().replace(""", "'"); } My javascript function: function updateFusionChart(condQuery,Mngmnt,stutus,kpi,serviceID){ alert("hi"); if ( !serviceID){ var strURL = "ChartServlet?GM=" + Mngmnt + "&status=" +stutus + "&kpi=" +kpi+ "&condQuery=" +condQuery; strURL = escape(strURL); var chart_CityDetails = new FusionCharts('FusionCharts/StackedBar3D.swf?ChartNoDataText=Click right chart to view Services Details', 'ServDetails', '550', '450', '0', '1'); chart_CityDetails.setDataURL(strURL); chart_CityDetails.render(Mngmnt+kpi+"ServDetailsDiv"); } else if (serviceID){ var strURL = "ChartServlet?GM=" + Mngmnt + "&status=" +stutus + "&serviceID=" +serviceID + "&kpi=" +kpi+"&condQuery="+condQuery; //URLEncode it - NECESSARY. strURL = escape(strURL); var chart_CityDetails = new FusionCharts('FusionCharts/StackedBar3D.swf?ChartNoDataText=Click right chart to view Services Details', 'SubServDetails', '800', '450', '0', '1'); chart_CityDetails.setDataURL(strURL); chart_CityDetails.render(Mngmnt+kpi+"SubServDetailsDiv"); } else { //Show error alert("Please wait for the charts to load."); return; } } My first chart is generating successfully. But when i clicked on a bar the link is not calling my javascript function .I tried with firebug .I am using a StackedBar3D. it was telling "syntax error javascript:updateFusionChart("1=1%20AND%20THE_DATE%20>=%20TO_DATE('01.01.2008',%20'DD.MM.YYYY')","Human%20Resources%20(Development)","Closed",""%20); Line 1 Please help me.

Thanks Sudipto for your great help. Its working fine now.

Hi sudipto, please find the attachments of xml,js and java file in which my chart is rendering . It will be very kind of you if you can give me a solution . xml.txt js.txt java.txt