espressoitalia

Members
 View Profile  See their activity

  • Content count

    2

  • Joined

  • Last visited

About espressoitalia

  • Rank
    Forum Newbie

  1. Combination Chart Column 3D Line (Single Y)

    espressoitalia replied to espressoitalia's topic in FusionCharts and ASP

    Hi thanks for your answer , this is my output xml data: <HTML> <HEAD> <TITLE> Sales per month quantity </TITLE> <SCRIPT LANGUAGE="Javascript" SRC="/NewSite/FusionCharts/Includes/FusionCharts.js"></SCRIPT> <style type="text/css"> <!-- body { font-family: Arial, Helvetica, sans-serif; font-size: 12px; } --> </style> </HEAD> <BODY> <CENTER> <!-- START Script Block for Chart productSales --> <div id='productSalesDiv' align='center'> Chart. </div> <script type="text/javascript"> //Instantiate the Chart var chart_productSales = new FusionCharts("/NewSite/FusionCharts/MSColumn3DLineDY.swf", "productSales", "400", "300", "0", "0"); //Provide entire XML data using dataXML method chart_productSales.setDataXML("<chart caption='Sales by Month' xAxisName='' showLegend ='0' formatNumberScale='6' rotateValues='1' placeValuesInside='1' decimals='0' showValues='0' numberPrefix='$' imageSave='1' imageSaveURL='/NewSite/FusionWidgets/ImageSaving/FusionChartsSave.aspx' labeldisplay='STAGGER' seriesNameInToolTip='0' plotSpacePercent='0'><styles><definition><style name='CanvasAnim' type='animation' param='_xScale' start='0' duration='1' /></definition><application><apply toObject='Canvas' styles='CanvasAnim' /></application></styles><categories><category name='July' /></categories><dataset seriesName='Tot' renderAs='COLUMN' parentYAxis='P' drawAnchors='1'><set toolText='Total Proposal' showValue='1' value='30317.62' /></dataset><trendlines><line startValue='10000' color='FF0000' displayValue='Sales Target $10000' showOnTop='0' thickness='1' isTrendZone='0' valueOnRight='1' /></trendlines><dataset seriesName='Tot' renderAs='COLUMN' parentYAxis='P' drawAnchors='1'><set toolText='Won' showValue='1' value='5451.72' /></dataset><dataset seriesName='Tot' renderAs='COLUMN' parentYAxis='P' drawAnchors='1'><set toolText='Lost' showValue='1' value='3364' /></dataset><dataset seriesName='Tot' renderAs='COLUMN' parentYAxis='P' drawAnchors='1'><set toolText='Abandon' showValue='1' value='6681' /></dataset><dataset seriesName='Qty' renderAs='Line' parentYAxis='S' drawAnchors='1'><set toolText='Total Proposal' showValue='1' value='5' /></dataset><dataset seriesName='Qty' renderAs='Line' parentYAxis='S' drawAnchors='1'><set toolText='Won' showValue='1' value='1' /></dataset><dataset seriesName='Qty' renderAs='Line' parentYAxis='S' drawAnchors='1'><set toolText='Lost' showValue='1' value='1' /></dataset><dataset seriesName='Qty' renderAs='Line' parentYAxis='S' drawAnchors='1'><set toolText='Abandon' showValue='1' value='1'/></dataset></chart>"); //Finally, render the chart. chart_productSales.render("productSalesDiv"); </script> <!-- END Script Block for Chart productSales --> </CENTER> </BODY> </HTML> have a good day!
  2. Hi guys, I post my code to do a charth combination 3d line: Dim arrData(1,5), arrDataQuantity(1,4) arrData(0,1) = MonthName(MeseAttuale) arrData(0,2) = TotalRevenueOpen arrData(0,3) = TotalRevenueWon arrData(0,4) = TotalRevenueLost arrData(0,5) = TotalRevenueAbandon arrDataQuantity(0,1) = TotalRevenueOpenQuantity arrDataQuantity(0,2) = TotalRevenueWonQuantity arrDataQuantity(0,3) = TotalRevenueLostQuantity arrDataQuantity(0,4) = TotalRevenueAbandonQuantity Dim strXML, strCategories, strTargetOpen, strOpen, strTagetWon, strWon, strLost, strAbandon, strOpenQuantity, strWonQuantity, strLostQuantity, strAbandonQuantity, i strXML = "<chart caption='Sales by Month' xAxisName='"&strCategories&"' showLegend ='0' formatNumberScale='6' rotateValues='1' placeValuesInside='1' decimals='0' showValues='0' numberPrefix='$' imageSave='1' imageSaveURL='/NewSite/FusionWidgets/ImageSaving/FusionChartsSave.aspx' labeldisplay='STAGGER' seriesNameInToolTip='0' plotSpacePercent='0'>" strCategories = "<categories>" strOpen = "<dataset seriesName='Tot' renderAs='COLUMN' parentYAxis='P' drawAnchors='1'>" strWon = "<dataset seriesName='Tot' renderAs='COLUMN' parentYAxis='P' drawAnchors='1'>" strLost = "<dataset seriesName='Tot' renderAs='COLUMN' parentYAxis='P' drawAnchors='1'>" strAbandon = "<dataset seriesName='Tot' renderAs='COLUMN' parentYAxis='P' drawAnchors='1'>" strOpenQuantity = "<dataset seriesName='Qty' renderAs='Line' parentYAxis='S' drawAnchors='1'>" strWonQuantity = "<dataset seriesName='Qty' renderAs='Line' parentYAxis='S' drawAnchors='1'>" strLostQuantity = "<dataset seriesName='Qty' renderAs='Line' parentYAxis='S' drawAnchors='1'>" strAbandonQuantity = "<dataset seriesName='Qty' renderAs='Line' parentYAxis='S' drawAnchors='1'>" For i=0 to UBound(arrData)-1 strCategories = strCategories & "<category name='" & arrData(i,1) & "' />" strOpen = strOpen & "<set toolText='Total Proposal' showValue='1' value='" & arrData(i,2) & "' />" strWon = strWon & "<set toolText='Won' showValue='1' value='" & arrData(i,3) & "' />" strLost = strLost & "<set toolText='Lost' showValue='1' value='" & arrData(i,4) & "' />" strAbandon = strAbandon & "<set toolText='Abandon' showValue='1' value='" & arrData(i,5) & "' />" strOpenQuantity = strOpenQuantity & "<set toolText='Total Proposal' showValue='1' value='" & arrDataQuantity(i,1) & "' />" strWonQuantity = strWonQuantity & "<set toolText='Won' showValue='1' value='" & arrDataQuantity(i,2) & "' />" strLostQuantity = strLostQuantity & "<set toolText='Lost' showValue='1' value='" & arrDataQuantity(i,3) & "' />" strAbandonQuantity = strAbandonQuantity & "<set toolText='Abandon' showValue='1' value='" & arrDataQuantity(i,4) & "'/>" Next strCategories = strCategories & "</categories>" strOpen = strOpen & "</dataset>" strWon = strWon & "</dataset>" strLost = strLost & "</dataset>" strAbandon = strAbandon & "</dataset>" strOpenQuantity = strOpenQuantity & "</dataset>" strWonQuantity = strWonQuantity & "</dataset>" strLostQuantity = strLostQuantity & "</dataset>" strAbandonQuantity = strAbandonQuantity & "</dataset>" strTagetWon = "<trendlines>" strTagetWon =strTagetWon & "<line startValue='" & SalesWonValue & "' color='FF0000' displayValue='Sales Target $" & SalesWonValue & "' showOnTop='0' thickness='1' isTrendZone='0' valueOnRight='1' />" strTagetWon = strTagetWon & "</trendlines>" strXML = strXML &"<styles>" strXML = strXML & "<definition>" strXML = strXML & "<style name='CanvasAnim' type='animation' param='_xScale' start='0' duration='1' />" strXML = strXML &"</definition>" strXML = strXML & "<application>" strXML = strXML & "<apply toObject='Canvas' styles='CanvasAnim' />" strXML = strXML & "</application>" strXML = strXML &"</styles>" strXML = strXML & strCategories & strOpen & strTagetWon & strWon & strLost & strAbandon& strOpenQuantity & strWonQuantity & strLostQuantity & strAbandonQuantity &"</chart>" Call renderChart("/NewSite/FusionCharts/MSColumn3DLineDY.swf", "", strXML, "productSales", 400, 300, false, false) My problem is join the same color.... The Columns area ok but the line dosen't work, I can see in the graph only the value but non in the right position, how can I anchor togheter two dataset? Have a good day!