Please enable JavaScript to view this site.

Reordering XY data

If you choose connecting lines on an XY graph, Prism connects the points in the order they appear on the data table. If the data are not sorted on the data table, the connecting lines will jump back and forth across the graph. If you want the connecting lines to go from left to right across the graph, first sort the data table by X values. Click on the Sort Rows button on the Change toolbar, and sort by X value.

 

sorting 1

Reordering Grouped data

Distinguish two ways to reverse order on a Grouped graph.

Reverse the order of rows

Click on the Sort Rows button on the Change toolbar, and reverse the order.

 

 

sorting 1

This example shows the effect of reversing the order of the rows in the data table.

sorting vs chang order 1

Reverse the plotting order of data set columns

Grouped tables are defined by two grouping variables. If you want to reverse the order of how the columns are graphed, you don't need to change the data table. Instead, go to the graph and click the Change data set order button. One of the choices on its menu reverses the order of data sets.

sorting3

This example shows the effect of reversing the plotting order of data sets. Note that this example starts with the same graph as the prior example.

sorting vs chang order 2

 

 

 

© 1995-2019 GraphPad Software, LLC. All rights reserved.