J
Jennifer
I am trying to chart a series of length measurements on
the X-axis plotted against a series of depths on the Y-
Axis. However, the depths are named in 5cm increments;
for example: 0-5, 5-10, 10-15., which excluded XY scatter
without modifying the desired labels. Furthermore I have
varying quantities of data for each depth range, which
excluded charting with the line charts as it is important
to maintain equal spacing between each of the axis
labels.
Currently, I have inserted a row of abitrary numbers,
representing the 5cm increments (for the Y-Axis) and have
successfully plotted all of the given plots.
Unfortunatly, now I need to somehow figure out how to
color code each of the plotted length/depth 'dots' in
regard to the unit they were removed. The only way I can
figure out how to do this is manually, but I have over
400 values and know there must be a better way.
Here is an example of my spreadsheet which may make all
of the aforementioned clearer:
(arbitrary)
unit level level code(y) shell length(mm)(X)
14/16 15-20 4 70.30
14/16 15-20 4 82.80
14/16 20-25 5 84.40
14/16 30-35 7 61.70
14/16 30-35 7 70.00
15/19 30-35 7 73.10
25/16 30-35 7 58.80
Thanks
the X-axis plotted against a series of depths on the Y-
Axis. However, the depths are named in 5cm increments;
for example: 0-5, 5-10, 10-15., which excluded XY scatter
without modifying the desired labels. Furthermore I have
varying quantities of data for each depth range, which
excluded charting with the line charts as it is important
to maintain equal spacing between each of the axis
labels.
Currently, I have inserted a row of abitrary numbers,
representing the 5cm increments (for the Y-Axis) and have
successfully plotted all of the given plots.
Unfortunatly, now I need to somehow figure out how to
color code each of the plotted length/depth 'dots' in
regard to the unit they were removed. The only way I can
figure out how to do this is manually, but I have over
400 values and know there must be a better way.
Here is an example of my spreadsheet which may make all
of the aforementioned clearer:
(arbitrary)
unit level level code(y) shell length(mm)(X)
14/16 15-20 4 70.30
14/16 15-20 4 82.80
14/16 20-25 5 84.40
14/16 30-35 7 61.70
14/16 30-35 7 70.00
15/19 30-35 7 73.10
25/16 30-35 7 58.80
Thanks