Line Chart draws in wrong x-axis order.

[Chris Dorger]

I am using Line Chart to create a trellis plot of data for a subject in a study. For some reason, it draws 2 of the 3 plots in the correctorder of visit. The last plot is drawn in some haphazard order. Why is this The data is sorted in the same way for all subjects. See the image of the data and the resulting plot. How can I fix it

[Colin Gray 3]

Hi there,

 

If you go to the Line Connection page in the properties for the line chart, you can set an 'order each line by' column, or just select to order it by your X axis values. Hopefully this sorts your issue.

 

Thanks

Colin

[Chris Dorger]

Thanks, Colin,

 

but Line Connection is under Scatter Plot not Line Chart.  Line Chart has "Line By".  When I use that to "Show one line for each Visit" I get no line connecting the points.  If is use it to "Show one line per subject", it does not draw the points in the correct order.  I think I am going to abandon Line Chart for this purpose.  Scatter Plot creates the correct plot.

 

 

[Colin Gray 3]

Ah sorry, my mistake! In general, I find using the scatter plot with a line connection more effective in more situations than the line chart anyway, so glad you got it working.

ThanksColin