Vb6 mschart graph - join two valid data point when inbetween data is null

Question

0.00/5 (No votes)

See more:

Hi Friends

I have been trying for past two days on this issue. I am plotting a graph by storing the values in an array from database.

I have to plot in such a way that the line should be continuous, even though some values are null. In my case, I am breaking the line were values are not there. But I need to join the lines with the next valid data instead of breaking.

Please, give me a solution, Your help will be greatly appreciated.

Thanks in advance
Raja Sebastin

Posted 23-Mar-11 3:33am

raja.sebastin

Updated 23-Mar-11 4:49am

Sandeep Mewara

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2011-03-23T04:50:00

Solution 1

I have to plot in such a way that the line should be continuous, even though some values are null. In my case, I am breaking the line were values are not there.

I guess, easiest would be to skip those points in the plot data that are null. Kind of filter them out. This would leave you with only valid data and a continuous graph. Based on what you say, null valued data holds no importance and so can be left out.

Posted 23-Mar-11 4:50am

Sandeep Mewara

Comments

raja.sebastin 25-Mar-11 8:51am

Thank u for ur reply

But the thing is i have two values to be plotted for a single array with reference to the x axis.

like for eg:

value 1 value 2 Date(x)
12 no value 01.03.2011
10 15 05.03.2011
15 no value 06.03.2011
25 10 08.03.2011

in the above case value1 is one line and value 2 is another line,
so value 1 will be continuous line since it has all values, but value2 line will be broken , instead i have to join 15 and 10 directly. but it should have reference to date.Now wt i am doing is i have used .datagrid to skip plotting null value, so the graph gets broken.

raja.sebastin 28-Mar-11 2:38am

Like in fusion charts they have the option connectNullData='1' for joining two data even though intermediate data is missing , plz help