Reg: Output as repeated input

Hi everyone,

I am working on vb6, macros with excel 2003...in the vb code I am able to claculate the mean value of the data and I need that value in the graph with a full line not at the point(Mean value)...could you plz help me how can I get that value for more than one time...

i.e if my mean value is 5, with that 5 only a dot in the graph is coming, but I want a single line at that particular point...so may be it'll be like if I can able to take that 5 as my input and if I repeat that value for 10 times then I can get 10 points on the graph...which is far better visible...

could you plz help me in this...

thnks in adv