manish.vadukul Report post Posted November 9, 2012 Hi I need reverse axis. At the moment its start from 0 bottom and 100 top. But i need 0 on top and 100 in below in axis Bcos i m doing Ranking chart. how can i do it in column2d or 3d. Regards Manish Share this post Link to post Share on other sites
manish.vadukul Report post Posted November 9, 2012 Hi Please help me. I am using evaluation chart. It says "no data to display" Public Function GetFactorySummayChartHtml() As String Dim xmlData As New StringBuilder() xmlData.Append("<chart caption='Website Ranking for the year 2006' xAxisName='Month' yAxisName='Revenue' showValues='0' numberPrefix='$'>") Dim factoryQuery As String = "exec test " Dim oRs As New DbConn(factoryQuery) While oRs.ReadData.Read() xmlData.Append("<set label='" & oRs.ReadData("SectionName").ToString() & "' value='" & oRs.ReadData("Rank").ToString & "' />") End While oRs.ReadData.Close() xmlData.Append("</chart>") Return FusionCharts.RenderChart("../Charts/InverseMSColumn2D.swf", "", xmlData.ToString(), "FactorySum", "600", "250", False, False) End Functionits not working. its working with column2D chart. But not with InverseMSColumn2D. But its working with your xml data not mine, But when i try your xml data than its working . Why is that.xml data below. Why is that. <chart caption='Business Results 2005 v 2006' xAxisName='Month' yAxisName='Revenue' showValues='0' numberPrefix='$'><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <categories><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Jan' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Feb' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Mar' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Apr' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='May' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Jun' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Jul' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Aug' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Sep' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Oct' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Nov' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Dec' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </categories><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <dataset seriesName='2006'><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='27400' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='29800'/><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='25800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='26800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='29600' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='32600' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='31800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='36700' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='29700' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='31900' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='34800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='24800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </dataset><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <dataset seriesName='2005'><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='10000'/><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='11500'/><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='12500'/><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='15000'/><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='11000' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='9800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='11800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='19700' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='21700' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='21900' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='22900' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='20800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </dataset><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <trendlines><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <line startValue='26000' color='91C728' displayValue='Target' showOnTop='1'/><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </trendlines><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <styles><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <definition><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <style name='CanvasAnim' type='animation' param='_xScale' start='0' duration='1' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </definition><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <application><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <apply toObject='Canvas' styles='CanvasAnim' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </application> <br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </styles><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"></chart> Share this post Link to post Share on other sites
Sanjukta Report post Posted November 10, 2012 HI, Hi Please help me. I am using evaluation chart. It says "no data to display" Public Function GetFactorySummayChartHtml() As String Dim xmlData As New StringBuilder() xmlData.Append("<chart caption='Website Ranking for the year 2006' xAxisName='Month' yAxisName='Revenue' showValues='0' numberPrefix='>") Dim factoryQuery As String = "exec test " Dim oRs As New DbConn(factoryQuery) While oRs.ReadData.Read() xmlData.Append("<set label='" & oRs.ReadData("SectionName").ToString() & "' value='" & oRs.ReadData("Rank").ToString & "' />") End While oRs.ReadData.Close() xmlData.Append("</chart>") Return FusionCharts.RenderChart("../Charts/InverseMSColumn2D.swf", "", xmlData.ToString(), "FactorySum", "600", "250", False, False) End Functionits not working. its working with column2D chart. But not with InverseMSColumn2D. But its working with your xml data not mine, But when i try your xml data than its working . Why is that.xml data below. Why is that. <chart caption='Business Results 2005 v 2006' xAxisName='Month' yAxisName='Revenue' showValues='0' numberPrefix='><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <categories><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Jan' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Feb' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Mar' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Apr' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='May' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Jun' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Jul' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Aug' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Sep' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Oct' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Nov' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <category label='Dec' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </categories><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <dataset seriesName='2006'><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='27400' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='29800'/><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='25800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='26800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='29600' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='32600' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='31800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='36700' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='29700' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='31900' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='34800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='24800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </dataset><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <dataset seriesName='2005'><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='10000'/><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='11500'/><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='12500'/><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='15000'/><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='11000' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='9800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='11800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='19700' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='21700' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='21900' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='22900' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <set value='20800' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </dataset><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <trendlines><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <line startValue='26000' color='91C728' displayValue='Target' showOnTop='1'/><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </trendlines><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <styles><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <definition><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <style name='CanvasAnim' type='animation' param='_xScale' start='0' duration='1' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </definition><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <application><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> <apply toObject='Canvas' styles='CanvasAnim' /><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </application> <br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"> </styles><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"><br style="color: rgb(41, 30, 64); font-family: 'Courier New', Courier, monospace; font-size: 12px; line-height: 18px;"></chart> Please note that if your chart shows a "No data to display" message, it could be the following scenarios: >> Your XML data doesn't contain any data that could be plotted by FusionCharts XT. In this case, your XML just contains the <chart> or <dataset> tags without any data between them. >> You might be using a single-series chart SWF and providing data in multi-series format or vice-versa. In this case too, you'll get a "No data to display" message. Could you please refer to the supported XML format of the Inverse Column chart with the help of the following link and see if this helps? Ref.- http://docs.fusioncharts.com/powercharts/Contents/?ChartSS/InverseColumn.htm Hope this helps. Share this post Link to post Share on other sites