Plotting part of a line chart?

[hin]

I am creating a forecast line chart via code that show the projected amount for the whole year with actual amount for the given month in another series. 

What I want to do is hide the "future" value of the actual amount.  For example in my screenshot, I am running the graph as of July. I don't have any data from Aug - Dec so it's zero or null.  How can I have the line stop at July or make the line invisible after July?  I don't want my graph to show a big drop from July to Aug.

https://docs.google.com/open?id=0ByWuNoN2Uz2DZG5NZ25yZGlOWXM

Thanks!

[Elian]

Hello Hin,

The chart series have properties which define the way null values will be handled. In order for the line to stop without reaching 0, set the following properties:

//this will connect the two points that have values != null
this.chart1.Series[0].Appearance.EmptyValue.Mode = Charting.Styles.EmtyValuesMode.Approximation;
//this will make the line invisible for the null values
this.chart1.Series[0].Appearance.EmptyValue.Line.Width = 0;

 
Kind regards,
Elian
the Telerik team

[hin]

Thank you Elian for pointing me in the right direction.  There was one piece of code that was missing.  I have to set the chartseriesitems to empty for this to work.

The extra code needed.

IF row("myamount") = 0 THEN
    mychartseriesitem.Empty = True
END IF