Hide line portions in chart

[David]

Hi guys,
I want to hide some line portions in a telerik chart, I don't know how to explain it, so I've created an  example image to show you my idea

 

How you can see in this case I assumed that in March there isn't any data, so the line must by invisible in that month

[Nasko]

Hello David,

By design the line will not be interrupted when there isn't any data for a particular month. You can work around this behavior by defining a separate line series for each line. For more information, please check the Graph help articles.

Regards,
Nasko
Telerik

 

 

[David]

Sorry but I don't understand, I've a datasource like this
for example for the line B in march I don't want anything, what would be the correct datasource?

[Nasko]

Hello David,

You will need to change your data source like this: screenshot.

Attached is a sample report demonstrating the approach.

Regards,
Nasko
Telerik

[David]

but where there are blank cell, for example(Jan, b) or (May, A) the value is null?

[David]

setting the value to null i'll recevive this errore message:

"An error has occured while processing Chart 'chart1':
Cannot set Column 'B' to be null. Please use DBNull instead."

[Roman]

So there is no solution to achieve hiding parts of line for null values, without creating separate series?

[Roman]

If I want chart appearance like here
http://www.telerik.com/clientsfiles/b78815cb-4e2b-4726-9897-45e928c60eba_Gap-default.png?sfvrsn=0

[Nasko]

Hello Roman,

To achieve the appearance of the chart in the provided screenshot you will need to create a separate series for each line.

Regards,
Nasko
Telerik