22 replies to this topic

[sth_syed]

Hi everybody,

i have some random values getting from text or from database etc.

I need X-Axis with fixed size of 10,25,75,90,95,100.

These were the grades given to students and i need fixed x-axis value.

Please help me in this regard.

hope you understand my problem.

Thanks and Regards
--Syed Thahir

[Basundhara Ghosal]

Hi,

Could you please specify the issue a bit elaborately?

Also, could you please send us a screen-shot of the same?

Awaiting your reply.

[sth_syed]

Hi ghosal,

Thanks for reply.

Sorry i mispelled x-axis for y-axis.

In the screen shot u may find the y-axis with the values 10,20,75,90,95,100 have only different colors or grade.

i need now only y-axis should display only values 10,20,75,90,95,100 .for color's i will use legends.

Hope this will help.

Awaiting your early reply.

thanks

Hi,

Could you please specify the issue a bit elaborately?

Also, could you please send us a screen-shot of the same?

Awaiting your reply.

[Basundhara Ghosal]

Hi,

In case you wish to specify the number of the divisional lines of the chart, please try setting the value of the attribute "numDivLines" in the <chart> element along with setting the value of the attribute "adjustDiv" to '0' in the <chart> element.

Please note, in this case you need to also specify the value of the attribute "yAxisMinValue" and "yAxisMaxValue" in the <chart> element.

Also, in case you wish not to display any specific color for the divlines, please try setting the value of the attribute "divLineAlpha" to '0' in the <chart> element.

Could you please also let us know the name and the version of the swf file that you are using?

For further reference, please refer to the link mentioned below :-

Ref.- http://www.fusioncha...c/DivLines.html

I hope this helps.

[sth_syed]

thanks for reply ghosal,

the value coming is random.

I need fixed values10,25,75,90,95,100.

I am using version 1.0.0.

Please help me in fixing Y-axis values - 10,25,75,90,95,100.

thanks

Hi,

In case you wish to specify the number of the divisional lines of the chart, please try setting the value of the attribute "numDivLines" in the <chart> element along with setting the value of the attribute "adjustDiv" to '0' in the <chart> element.

Please note, in this case you need to also specify the value of the attribute "yAxisMinValue" and "yAxisMaxValue" in the <chart> element.

Also, in case you wish not to display any specific color for the divlines, please try setting the value of the attribute "divLineAlpha" to '0' in the <chart> element.

Could you please also let us know the name and the version of the swf file that you are using?

For further reference, please refer to the link mentioned below :-

Ref.- http://www.fusioncha...c/DivLines.html

I hope this helps.

[Sanjukta]

Hi,

Please try setting the attributes "divLineAlpha" and "showYAxisValues" to '0' in the <chart> element.
Ex: <chart divLineAlpha='0' showYAxisValues='0' >

Also, try creating trendlines of the particular values to display only the lines you intend to display.
Ex: <trendLines>
<line startValue='10' color='000000' displayValue='10' />
<line startValue='25' color='000000' displayValue='25' />
<line startValue='75' color='000000' displayValue='75' />
<line startValue='90' color='000000' displayValue='90' />
<line startValue='95' color='000000' displayValue='95' />
<line startValue='100' color='000000' displayValue='100' />
</trendLines>

Hope this helps.

[sth_syed]

Thanks Sanjukta,

You code may be fine but i have already Visual Basic 6.0 Code displaying DATA can you help in this regards

chartParameters = "caption=Graph for Student Result;xAxisName=Result;yAxisName=Score"

Call FusionCharts1.Data.addCategory("")

Call FusionCharts1.Data.addDataset("D ", "color=D00B00")
Call FusionCharts1.Data.addDataset("C", "color=706E00")
Call FusionCharts1.Data.addDataset("B", "color=4FEE4C")

Dim Grade
Grade = Format(LTrim(RTrim(Form9.Text18.Text)))

If Grade <= 10 Then
FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=D00B00")
ElseIf Grade > 10 And Grade <= 25 Then
FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=706E00")
ElseIf Grade > 25 And Grade <= 75 Then
FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=4FEE4C")
ElseIf Grade > 75 And Grade <= 90 Then
FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=33B6B1")
ElseIf Grade > 90 And Grade <= 95 Then
FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=7040BB")
ElseIf Grade > 95 Then
FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=AAAA10")
End If

Call FusionCharts1.Data.addDataset(" B+ ", "color=33B6B1")
Call FusionCharts1.Data.addDataset(" A ", "color=7040BB")
Call FusionCharts1.Data.addDataset(" A+", "color=AAAA10")

Call FusionCharts1.Data.setChartParams(chartParameters)

FusionCharts1.RenderChart

This display's Bar chart fine depanding on value but i need fixed values of y-axis (10,25,75,90,95,100) if possible line

Thanks.

Any additional information need will be provided.

Hi,

Please try setting the attributes "divLineAlpha" and "showYAxisValues" to '0' in the <chart> element.
Ex: <chart divLineAlpha='0' showYAxisValues='0' >

Also, try creating trendlines of the particular values to display only the lines you intend to display.
Ex: <trendLines>
<line startValue='10' color='000000' displayValue='10' />
<line startValue='25' color='000000' displayValue='25' />
<line startValue='75' color='000000' displayValue='75' />
<line startValue='90' color='000000' displayValue='90' />
<line startValue='95' color='000000' displayValue='95' />
<line startValue='100' color='000000' displayValue='100' />
</trendLines>

Hope this helps.

[Rahul Kumar]

Hi,

Could you please try using the following code?

    Dim chartParameters  As String

    FusionCharts1.ChartType = mscolumn2d
    chartParameters = "caption=Graph for Student Result;xAxisName=Result;yAxisName=Score;divLineAlpha=0;yAxisMaxValue=100"
    
    Call FusionCharts1.Data.addCategory("")
    
    Call FusionCharts1.Data.addDataset("D ", "color=D00B00")
    Call FusionCharts1.Data.addDataset("C", "color=706E00")
    Call FusionCharts1.Data.addDataset("B", "color=4FEE4C")
    
    Dim Grade
    Grade = Format(LTrim(RTrim(Form9.Text18.Text)))
    
    If Grade <= 10 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=D00B00")
    ElseIf Grade > 10 And Grade <= 25 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=706E00")
    ElseIf Grade > 25 And Grade <= 75 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=4FEE4C")
    ElseIf Grade > 75 And Grade <= 90 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=33B6B1")
    ElseIf Grade > 90 And Grade <= 95 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=7040BB")
    ElseIf Grade > 95 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=AAAA10")
    End If

    Call FusionCharts1.Data.addDataset(" B+ ", "color=33B6B1")
    Call FusionCharts1.Data.addDataset(" A ", "color=7040BB")
    Call FusionCharts1.Data.addDataset(" A+", "color=AAAA10")
    
    Call FusionCharts1.Data.setChartParams(chartParameters)
    Call FusionCharts1.Data.addTrendLine("startValue=0;endValue=10;isTrendZone=1;color=D00B00;displayValue= ;alpha=100")
    Call FusionCharts1.Data.addTrendLine("startValue=10;endValue=25;isTrendZone=1;color=706E00;displayValue= ;alpha=100")
    Call FusionCharts1.Data.addTrendLine("startValue=25;endValue=75;isTrendZone=1;color=4FEE4C;displayValue= ;alpha=100")
    Call FusionCharts1.Data.addTrendLine("startValue=75;endValue=90;isTrendZone=1;color=33B6B1;displayValue= ;alpha=100")
    Call FusionCharts1.Data.addTrendLine("startValue=90;endValue=95;isTrendZone=1;color=7040BB;displayValue= ;alpha=100")
    Call FusionCharts1.Data.addTrendLine("startValue=95;endValue=100;isTrendZone=1;color=AAAA10;displayValue= ;alpha=100")


    FusionCharts1.RenderChart

[sth_syed]

Hi Thanks for the Reply Code work fine.

But the values in Y-Axis display in middle not exactly in the line.

I have send the screen1 shot of the report i got with chart showing value 50 but the color range green with value 75 show in middle range and i want it in the line as in the image screen2 exactly in the line.

Hope u understand my problem.

Thanks for the reply.

Hi,

Could you please try using the following code?

    Dim chartParameters  As String

    FusionCharts1.ChartType = mscolumn2d
    chartParameters = "caption=Graph for Student Result;xAxisName=Result;yAxisName=Score;divLineAlpha=0;yAxisMaxValue=100"
    
    Call FusionCharts1.Data.addCategory("")
    
    Call FusionCharts1.Data.addDataset("D ", "color=D00B00")
    Call FusionCharts1.Data.addDataset("C", "color=706E00")
    Call FusionCharts1.Data.addDataset("B", "color=4FEE4C")
    
    Dim Grade
    Grade = Format(LTrim(RTrim(Form9.Text18.Text)))
    
    If Grade <= 10 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=D00B00")
    ElseIf Grade > 10 And Grade <= 25 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=706E00")
    ElseIf Grade > 25 And Grade <= 75 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=4FEE4C")
    ElseIf Grade > 75 And Grade <= 90 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=33B6B1")
    ElseIf Grade > 90 And Grade <= 95 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=7040BB")
    ElseIf Grade > 95 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=AAAA10")
    End If

    Call FusionCharts1.Data.addDataset(" B+ ", "color=33B6B1")
    Call FusionCharts1.Data.addDataset(" A ", "color=7040BB")
    Call FusionCharts1.Data.addDataset(" A+", "color=AAAA10")
    
    Call FusionCharts1.Data.setChartParams(chartParameters)
    Call FusionCharts1.Data.addTrendLine("startValue=0;endValue=10;isTrendZone=1;color=D00B00;displayValue= ;alpha=100")
    Call FusionCharts1.Data.addTrendLine("startValue=10;endValue=25;isTrendZone=1;color=706E00;displayValue= ;alpha=100")
    Call FusionCharts1.Data.addTrendLine("startValue=25;endValue=75;isTrendZone=1;color=4FEE4C;displayValue= ;alpha=100")
    Call FusionCharts1.Data.addTrendLine("startValue=75;endValue=90;isTrendZone=1;color=33B6B1;displayValue= ;alpha=100")
    Call FusionCharts1.Data.addTrendLine("startValue=90;endValue=95;isTrendZone=1;color=7040BB;displayValue= ;alpha=100")
    Call FusionCharts1.Data.addTrendLine("startValue=95;endValue=100;isTrendZone=1;color=AAAA10;displayValue= ;alpha=100")


    FusionCharts1.RenderChart

Attached Thumbnails

• 
• 

[sth_syed]

Hi Guys what about my query.

Waiting for your reply

thanks

Hi Thanks for the Reply Code work fine.

But the values in Y-Axis display in middle not exactly in the line.

I have send the screen1 shot of the report i got with chart showing value 50 but the color range green with value 75 show in middle range and i want it in the line as in the image screen2 exactly in the line.

Hope u understand my problem.

Thanks for the reply.

[Basundhara Ghosal]

Hi,

Our development team is looking into the issue.

We will get back to you as soon as possible.

[sth_syed]

Thanks ghosal

Hi,

Our development team is looking into the issue.

We will get back to you as soon as possible.

[Rahul Kumar]

Hi Sayed,

In the first screen shot (Screen1) the Y-Axis values are not exactly Y-Axis values it is Trendline (Zone) values, and if your want your output exactly as Screen2 then your would need to pass displayValue= ; in addTrendLine method parameter and showYAxisValues=1 in setChartParams method. And the sample code will be same as I posted earlier.

Call FusionCharts1.Data.addTrendLine("startValue=0;endValue=10;isTrendZone=1;color=D00B00;displayValue= ;alpha=100")

I hope you want the output same as shown in image.jpg (attached).

Attached Thumbnails

• 

[sth_syed]

Sorry Rahul,

this is not my Desired result.

I need Y-axis with the values 10,25,75,90,95,100 only exactly beside the line.

This code didnot give the desired result and i already tried it also.

hope u understand my situation

Hi Sayed,

In the first screen shot (Screen1) the Y-Axis values are not exactly Y-Axis values it is Trendline (Zone) values, and if your want your output exactly as Screen2 then your would need to pass displayValue= ; in addTrendLine method parameter and showYAxisValues=1 in setChartParams method. And the sample code will be same as I posted earlier.

Call FusionCharts1.Data.addTrendLine("startValue=0;endValue=10;isTrendZone=1;color=D00B00;displayValue= ;alpha=100")

I hope you want the output same as shown in image.jpg (attached).

[Rahul Kumar]

Hi Syed,

Could you please attach an image by manually highlighting the area to show us what you need?

[sth_syed]

Hi Rahul,

I have attached an image of an old report with this.

There in Y-axis u have random numbers and the numbers 10,25,75,90,95,100 represent particular grade.

I need only 10,25,75,90,95,100 this number in Y-axis .

Exactly shown in old Chart.

Please help me in this regard.

Thanks.

Hi Syed,

Could you please attach an image by manually highlighting the area to show us what you need?

Attached Thumbnails

• 

[sth_syed]

Hi Guys'

I am waititng for your reply.

Thanks

Hi Rahul,

I have attached an image of an old report with this.

There in Y-axis u have random numbers and the numbers 10,25,75,90,95,100 represent particular grade.

I need only 10,25,75,90,95,100 this number in Y-axis .

Exactly shown in old Chart.

Please help me in this regard.

Thanks.

[Sanjukta]

Hi,

We are looking into the issue.

We shall get back to your as soon we come up with a solution.

Thanks for your continued patience and patronage.

[Rahul Kumar]

Hi Syed,

Sorry for the delay.

I am afraid this type of chart is not possible as of now, but you can always create a chart like the attached image. Please let us know if you need the same chart which is shown in the attached image, we'll give you the source code for that.

[sth_syed]

thanks for reply Rahul.

Please do send the Code for the Chart.

Hi Syed,

Sorry for the delay.

I am afraid this type of chart is not possible as of now, but you can always create a chart like the attached image. Please let us know if you need the same chart which is shown in the attached image, we'll give you the source code for that.

[Rahul Kumar]

Hi Syed,

Please find the code below:

    Dim chartParameters  As String

    FusionCharts1.ChartType = mscolumn3d
    chartParameters = "showValues=1;caption=Graph for Student Result;xAxisName=Result;yAxisName=Score;yAxisMaxValue=100;yAxisMinValue=10;showYaxisValues=1;divLineAlpha=100;divLineColor=000000"
    
    Call FusionCharts1.Data.addCategory("")
    
    Call FusionCharts1.Data.addDataset("D ", "color=D00B00")
    Call FusionCharts1.Data.addDataset("C", "color=706E00")
    Call FusionCharts1.Data.addDataset("B", "color=4FEE4C")
    
    Dim Grade
    Grade = Format(LTrim(RTrim(Form9.Text18.Text)))
    
    If Grade <= 10 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=D00B00")
    ElseIf Grade > 10 And Grade <= 25 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=706E00")
    ElseIf Grade > 25 And Grade <= 75 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=4FEE4C")
    ElseIf Grade > 75 And Grade <= 90 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=33B6B1")
    ElseIf Grade > 90 And Grade <= 95 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=7040BB")
    ElseIf Grade > 95 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=AAAA10")
    End If

    Call FusionCharts1.Data.addDataset(" B+ ", "color=33B6B1")
    Call FusionCharts1.Data.addDataset(" A ", "color=7040BB")
    Call FusionCharts1.Data.addDataset(" A+", "color=AAAA10")
    
    Call FusionCharts1.Data.setChartParams(chartParameters)
    Call FusionCharts1.Data.addTrendLine("startValue=0;endValue=10;isTrendZone=1;color=D00B00;displayValue= ;alpha=50")
    Call FusionCharts1.Data.addTrendLine("startValue=10;endValue=25;isTrendZone=1;color=706E00;displayValue= ;alpha=50")
    Call FusionCharts1.Data.addTrendLine("startValue=25;endValue=75;isTrendZone=1;color=4FEE4C;displayValue= ;alpha=70")
    Call FusionCharts1.Data.addTrendLine("startValue=75;endValue=90;isTrendZone=1;color=33B6B1;displayValue= ;alpha=70")
    Call FusionCharts1.Data.addTrendLine("startValue=90;endValue=95;isTrendZone=1;color=7040BB;displayValue= ;alpha=50")
    Call FusionCharts1.Data.addTrendLine("startValue=95;endValue=100;isTrendZone=1;color=AAAA10;displayValue= ;alpha=50")
    
    FusionCharts1.RenderChart

[sth_syed]

Thanks for the Code, Waiting for the approval from mgmt.

Hi Syed,

Please find the code below:

    Dim chartParameters  As String

    FusionCharts1.ChartType = mscolumn3d
    chartParameters = "showValues=1;caption=Graph for Student Result;xAxisName=Result;yAxisName=Score;yAxisMaxValue=100;yAxisMinValue=10;showYaxisValues=1;divLineAlpha=100;divLineColor=000000"
    
    Call FusionCharts1.Data.addCategory("")
    
    Call FusionCharts1.Data.addDataset("D ", "color=D00B00")
    Call FusionCharts1.Data.addDataset("C", "color=706E00")
    Call FusionCharts1.Data.addDataset("B", "color=4FEE4C")
    
    Dim Grade
    Grade = Format(LTrim(RTrim(Form9.Text18.Text)))
    
    If Grade <= 10 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=D00B00")
    ElseIf Grade > 10 And Grade <= 25 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=706E00")
    ElseIf Grade > 25 And Grade <= 75 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=4FEE4C")
    ElseIf Grade > 75 And Grade <= 90 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=33B6B1")
    ElseIf Grade > 90 And Grade <= 95 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=7040BB")
    ElseIf Grade > 95 Then
        FusionCharts1.Data.addChartData (" " & Format(LTrim(RTrim(Form9.Text18.Text))) & ""), ("color=AAAA10")
    End If

    Call FusionCharts1.Data.addDataset(" B+ ", "color=33B6B1")
    Call FusionCharts1.Data.addDataset(" A ", "color=7040BB")
    Call FusionCharts1.Data.addDataset(" A+", "color=AAAA10")
    
    Call FusionCharts1.Data.setChartParams(chartParameters)
    Call FusionCharts1.Data.addTrendLine("startValue=0;endValue=10;isTrendZone=1;color=D00B00;displayValue= ;alpha=50")
    Call FusionCharts1.Data.addTrendLine("startValue=10;endValue=25;isTrendZone=1;color=706E00;displayValue= ;alpha=50")
    Call FusionCharts1.Data.addTrendLine("startValue=25;endValue=75;isTrendZone=1;color=4FEE4C;displayValue= ;alpha=70")
    Call FusionCharts1.Data.addTrendLine("startValue=75;endValue=90;isTrendZone=1;color=33B6B1;displayValue= ;alpha=70")
    Call FusionCharts1.Data.addTrendLine("startValue=90;endValue=95;isTrendZone=1;color=7040BB;displayValue= ;alpha=50")
    Call FusionCharts1.Data.addTrendLine("startValue=95;endValue=100;isTrendZone=1;color=AAAA10;displayValue= ;alpha=50")
    
    FusionCharts1.RenderChart

[Basundhara Ghosal]

Hi,

Hope this could be of your help.

Happy FusionCharting.