Sign in to follow this  
manish.vadukul

Y Axis Ranking

Recommended Posts

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

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

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this