Hello everyone,

I have this problem where I need to draw a line for points that don'
exist.

Example:
I need to plot the data below preserving the scale, which means where
don't have point 4 I still need to have something on the chart, eithe
average or interpolated value.

Category --- Value
1 ------------ 1
2 ------------ 4
3 ------------ 9
5 ------------ 25
6 ------------ 36

I know that SCATTER type chart does it automatically, but I have such
complex chart that does not fit into this category and therefore gaps i
the category array are not displayed.
Is there a property of a chart object that I can use, which is simila
to what SCATTER chart has?
And also is there a way to mark those points which are missing? Fo
example scatter chart does not mark missing points and marks onl
existing points, I think there should be a way to do the opposite.

Thank you in advance for all the ideas.

Ivan

--
Intellihom
-----------------------------------------------------------------------
Intellihome's Profile: http://www.msusenet.com/member.php?userid=147
View this thread: http://www.msusenet.com/t-187089859