Please enable JavaScript to view this site.

Navigation: Data tables > Creating data tables

Creating a table to create a scatter plot

Scroll Prev Top Next More

Prism offers seven distinct types of data tables. Three of these can be used to create scatter graphs.

XY scatter graphs

With an XY data table, each X value can have several replicates for every data set. When you make your graph, you can choose to show all the replicates on your graph instead of error bars. Start with an XY table if you want to show all your replicates for each X value.

which table scatter 2

Here is the data table for the graph above.

which table scatter 3

To format an XY graph to show each data point as in the graph above, click on the Format Graph button on the toolbar, select Global to choose all data sets, and choose to Show each Replicate. To show mean and error instead, choose Mean and Error from this drop-down menu instead.



which table scatter 4

Column scatter graphs

If you want to compare groups and show every data point along with lines for mean and error for each group, start with a column table. All the data values for each group should be entered in a single column.


which table scatter 5


To make the graph above, start with a Column table and enter all the data points for each data set in a column. Prism will create error bars from all the data points in each column.

which table scatter 7


If you instead want a graph that shows only the mean and error for each data set, double click on any data point to open the Format Graph dialog and choose "One symbol per column" and the type of error you want to show.

which table scatter 8

Grouped scatter graphs

If you want to create a scatter plot comparing groups by more than one variable, enter data on a Grouped data table with side by side replicates.


which table scatter 12

Here are the data plotted as an interleaved graph:

scatter - grouped


You can also choose to superimpose the groups:


which table scatter 11










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