Chart showing one line for several rows
 

I have rows with varying number of filled (with figures) cells (from 1 to 100
per row). I want to create a chart showing a line where the first data point
is the first cell in the first row and the last datapoint is the last cell in
the last row.
Ex.
a b c d e f
1 500 450 525
2 495
3 502 465 515 498 507 492
4 465 516

The chart has to show this line:
500 450 525 495 502 465 515 498 507 492 465 516

How can I do it automicaly (macro) because I have to do the operation agian
and again.
Regards