Y
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.
+-------------------------------------------------------------------+
|Filename: Bar by bar data of $imulator trades.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3814 |
+-------------------------------------------------------------------+
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.
+-------------------------------------------------------------------+
|Filename: Bar by bar data of $imulator trades.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3814 |
+-------------------------------------------------------------------+