If the number of y data points is uneven when importing two separated columns from excel (as in, you need to hold ctrl to select them), the longer data gets truncated.
This only happens if the columns are separated, you use ctrl to select them, and if the last column is the shorter one.
Examples:
Sorry, it's dropping the formatting in my post but if you click edit as admin or click "quote" you should see the formatting.
This gets truncated:
X Y1 Y2
0.28 128109.6023 136513.3172
0.3 123353.2152 131468.3675
0.32 116310.8059 124168.3574
0.34 111313.4909 118948.3447
0.36 107922.1955 115369.882
0.38 105756.033
0.4 103903.3047
0.42 101940.2787
This does not get truncated:
X Y2 Y1
0.28 136513.3172 128109.6023
0.3 131468.3675 123353.2152
0.32 124168.3574 116310.8059
0.34 118948.3447 111313.4909
0.36 115369.882 107922.1955
0.38 105756.033
0.4 103903.3047
0.42 101940.2787
This does not get truncated:
X Y2 Y1
0.28 136513.3172 128109.6023
0.3 131468.3675 123353.2152
0.32 124168.3574 116310.8059
0.34 118948.3447 111313.4909
0.36 115369.882 107922.1955
0.38 105756.033
0.4 103903.3047
0.42 101940.2787
Truncated y data with separated columns imported from excel
Moderator: DPlotAdmin
- DPlotAdmin
- Posts: 2312
- Joined: Tue Jun 24, 2003 9:34 pm
- Location: Vicksburg, Mississippi
- Contact:
Thanks for pointing out the problem. I'll fix that before the next release.
Visualize Your Data
support@dplot.com
support@dplot.com