Printable View
I am producing a series of line charts. The problem arises where there is a missing value (or a value outside the min/max value range). In this case the line jumps the the bottom or top of the chart. What I require is the ability to leave gaps in the line when this occurs so that the trend is still visible but the fact that there are missing (or suspect) values is shown. This feature is possible in Excel but I have not been able to find anything similar in VB6.
That was always a real pain whenever I tried.
The only thing you can do is set the value to be equi-distant between the values either side of it and consider that it is the "average" of the 2 values returned.
In reality it is not possible to get a line that has gaps in it... by definition of there is "no value" then it is correctly represented as having a value of 0.
You would have to go to a PLOT graph instead of a line graph to simular something that simply has an X,Y coordinate rather than a line which is "supposed" to travel from point A to point B... if there is no point B then it isn't a line ;)