So when I create an XY Line chart, I add the XY values in that order as described, yet when the lines are connected, they don't follow the order I inserted them in. Instead, they create the form of an oval with zig zag lines.
ex: (what I want)
values : (1,2), (2,3), (3,2), (2,1)
Code: Select all
3| X
+| / \
2| X X
+| \ /
1| X
+-----------
0 1 2 3
Code: Select all
3| X
+| |\
2| X | X
+| \|
1| X
+-----------
0 1 2 3