User (Legacy) Posted April 3, 2003 Report Share Posted April 3, 2003 Can someone please tell whats wrong with thisline of Code: Chart1.ValueEx(c, j) = FormatNumber(YearlyReturns©, 0) The complete area is below. Thanx a lot, Raj. Chart1.OpenDataEx COD_YVALUES, Years, 2 For c = 0 to (Years - 1) n = n + 1 For j = 0 to 1 If j = 0 Then Chart1.ValueEx(c, j) = FormatNumber(YearlyReturns©, 0) Else Chart1.ValueEx(c, j) = (0 - FormatNumber(Drawdowns©, 0)) End If Chart1.OpenDataEx COD_COLORS,2,2 If j = 0 Then Chart1.Color(j) = &H990000& Else Chart1.Color(j) = &H990066& End If Chart1.CloseData COD_COLORS Next Chart1.Axis(AXIS_Y).Label© = n Next Chart1.CloseData COD_YVALUES Link to comment Share on other sites More sharing options...
Software FX Posted April 3, 2003 Report Share Posted April 3, 2003 ValueEx expects a number as a parameter, FormatNumber returns a string with the desired formatting. You need to assign numbers to ChartFX, the number of decimals and other formatting options needs to be handled using our API (specifically using the Axis object). -- Regards, JC Software FX Support "Raj Datta" <rajatrd@hotmail.com> wrote in message news:2xgAStb#CHA.1248@webserver1.softwarefx.com... Can someone please tell whats wrong with thisline of Code: Chart1.ValueEx(c, j) = FormatNumber(YearlyReturns©, 0) The complete area is below. Thanx a lot, Raj. Chart1.OpenDataEx COD_YVALUES, Years, 2 For c = 0 to (Years - 1) n = n + 1 For j = 0 to 1 If j = 0 Then Chart1.ValueEx(c, j) = FormatNumber(YearlyReturns©, 0) Else Chart1.ValueEx(c, j) = (0 - FormatNumber(Drawdowns©, 0)) End If Chart1.OpenDataEx COD_COLORS,2,2 If j = 0 Then Chart1.Color(j) = &H990000& Else Chart1.Color(j) = &H990066& End If Chart1.CloseData COD_COLORS Next Chart1.Axis(AXIS_Y).Label© = n Next Chart1.CloseData COD_YVALUES Link to comment Share on other sites More sharing options...
Software FX Posted April 3, 2003 Report Share Posted April 3, 2003 Try replacing COD_YVALUES with COD_VALUES (COD_YVALUES is not defined in our inc so ASP is assuming a 0 value), BTW are you including our INC value ? -- Regards, JC Software FX Support "news.softwarefx.com" <rajatrd@hotmail.com> wrote in message news:5ZiJSQf#CHA.1248@webserver1.softwarefx.com... > Still same problem still same line. > > Chart1.ValueEx(c, j) = YearlyReturns© > > Thanx, > Raj. > > "Software FX Support" <support@softwarefx.com> wrote in message > news:X#RvqBf#CHA.1248@webserver1.softwarefx.com... > > ValueEx expects a number as a parameter, FormatNumber returns a string > with > > the desired formatting. You need to assign numbers to ChartFX, the number > of > > decimals and other formatting options needs to be handled using our API > > (specifically using the Axis object). > > > > -- > > Regards, > > > > JC > > Software FX Support > > "Raj Datta" <rajatrd@hotmail.com> wrote in message > > news:2xgAStb#CHA.1248@webserver1.softwarefx.com... > > Can someone please tell whats wrong with thisline of Code: > > Chart1.ValueEx(c, j) = FormatNumber(YearlyReturns©, 0) > > > > The complete area is below. > > > > Thanx a lot, > > Raj. > > > > Chart1.OpenDataEx COD_YVALUES, Years, 2 > > For c = 0 to (Years - 1) > > n = n + 1 > > For j = 0 to 1 > > If j = 0 Then > > Chart1.ValueEx(c, j) = FormatNumber(YearlyReturns©, 0) > > Else > > Chart1.ValueEx(c, j) = (0 - FormatNumber(Drawdowns©, 0)) > > End If > > Chart1.OpenDataEx COD_COLORS,2,2 > > If j = 0 Then > > Chart1.Color(j) = &H990000& > > Else > > Chart1.Color(j) = &H990066& > > End If > > Chart1.CloseData COD_COLORS > > Next > > Chart1.Axis(AXIS_Y).Label© = n > > Next > > Chart1.CloseData COD_YVALUES > > > > > > Link to comment Share on other sites More sharing options...
Software FX Posted April 3, 2003 Report Share Posted April 3, 2003 Still same problem still same line. Chart1.ValueEx(c, j) = YearlyReturns© Thanx, Raj. "Software FX Support" <support@softwarefx.com> wrote in message news:X#RvqBf#CHA.1248@webserver1.softwarefx.com... > ValueEx expects a number as a parameter, FormatNumber returns a string with > the desired formatting. You need to assign numbers to ChartFX, the number of > decimals and other formatting options needs to be handled using our API > (specifically using the Axis object). > > -- > Regards, > > JC > Software FX Support > "Raj Datta" <rajatrd@hotmail.com> wrote in message > news:2xgAStb#CHA.1248@webserver1.softwarefx.com... > Can someone please tell whats wrong with thisline of Code: > Chart1.ValueEx(c, j) = FormatNumber(YearlyReturns©, 0) > > The complete area is below. > > Thanx a lot, > Raj. > > Chart1.OpenDataEx COD_YVALUES, Years, 2 > For c = 0 to (Years - 1) > n = n + 1 > For j = 0 to 1 > If j = 0 Then > Chart1.ValueEx(c, j) = FormatNumber(YearlyReturns©, 0) > Else > Chart1.ValueEx(c, j) = (0 - FormatNumber(Drawdowns©, 0)) > End If > Chart1.OpenDataEx COD_COLORS,2,2 > If j = 0 Then > Chart1.Color(j) = &H990000& > Else > Chart1.Color(j) = &H990066& > End If > Chart1.CloseData COD_COLORS > Next > Chart1.Axis(AXIS_Y).Label© = n > Next > Chart1.CloseData COD_YVALUES > > Link to comment Share on other sites More sharing options...
Software FX Posted April 3, 2003 Report Share Posted April 3, 2003 Thanx, I got it to work with Values instead of YValues and including the include file. :-) But now the bars are showing up too thin. Chart1.RightGap=20 Chart1.LeftGap=1 Chart1.TopGap = 10 Chart1.BottomGap = 24 Chart1.RGBBk = &HFFFFFF& Chart1.RGB2DBk = &HFFFFFF& Chart1.Axis(0).Grid = True Chart1.Axis(0).autoscale=1 Chart1.Axis(0).Format = 2 Chart1.Axis(0).Decimals = 0 Chart1.Axis(1).autoscale=1 Chart1.Axis(1).Format = 0 Chart1.Axis(1).Decimals = 0 Chart1.AxesStyle = 0 Chart1.BorderStyle = 0 Chart1.Gallery = BAR Chart1.Volume = 100 Link to comment Share on other sites More sharing options...
Software FX Posted April 3, 2003 Report Share Posted April 3, 2003 I got it to work! Thanx, Raj. "news.softwarefx.com" <rajatrd@hotmail.com> wrote in message news:ch4h#dg#CHA.688@webserver1.softwarefx.com... > Thanx, I got it to work with Values instead of YValues and including the > include file. :-) > But now the bars are showing up too thin. > > Chart1.RightGap=20 > Chart1.LeftGap=1 > Chart1.TopGap = 10 > Chart1.BottomGap = 24 > Chart1.RGBBk = &HFFFFFF& > Chart1.RGB2DBk = &HFFFFFF& > Chart1.Axis(0).Grid = True > Chart1.Axis(0).autoscale=1 > Chart1.Axis(0).Format = 2 > Chart1.Axis(0).Decimals = 0 > Chart1.Axis(1).autoscale=1 > Chart1.Axis(1).Format = 0 > Chart1.Axis(1).Decimals = 0 > Chart1.AxesStyle = 0 > Chart1.BorderStyle = 0 > Chart1.Gallery = BAR > Chart1.Volume = 100 > > Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.