Data transforming and zigzag figure poltting

[yoyo2000]

Hi,guys,I met a problem when I was going to transfor and plot a group of data.
There are three Tabs in the data in attachment,those in the first Tab are raw data;
and the data in the second Tab are transfered percent data, the transfering rules are:
the 2nd and latter data divide the first col data in each line,and the results are in percent mode.the problem is,the lengths of each line are not the same,how to hide the unavailable result?
the third Tab is the plotting chart according to the data in Tab 2.a line data,a zigzag.the problem is,how to plot the lines automaticly,and add a linear line for the whole zigzags?

Thanks in advance.