Creating a chart with multiple data-sources that have variable ranges ( in VBA)

Hello there, I have some issues creating a chart.


Context:
I have to create a milestone slip chart (time-time chart). In order to achieve this I have:

- one column with the date of every day on a certain number of years (represents my X axis)
Content in this column goes from cell (3,3) to cell (i -1 ,3)

- 9 columns of values (one for each milestone). The cells in these columns have either a value or no value ( this value is a date and is linked to a date on the x axis) (column index = 5,7,9... = 2 + k * 2 with k from 1 to 8)

I need to plot a line for each milestone.

here is my code:

Please Login or Register  to view this content.

but it shows a run-time error 1004 ( application-defined or object-defined error) at this part of code

Please Login or Register  to view this content.

I have looked for hours on the net to find a solution and tried different syntax but nothing seems to work due to the variables i and k

Thanks in advance

Anyone?... Please?

Thanks a lot for your time and answer, I'll try this tomorrow morning at work and tell you my results!