Skip to main content
All CollectionsUsing the Data Table and Graphing Tools
Using the New Data Table and Graphing Tool
Using the New Data Table and Graphing Tool

How to use the new Pivot Interactives Data Table and Graphing Tool

Trevor Register avatar
Written by Trevor Register
Updated over a year ago

Set up your data table and enter data

You can enter column headings for the data table by clicking on each field in the column heading and typing values:

  • Column name: text name for the quantity in this column

  • units: the units of measurement for this quantity if the column is a number

  • variable: an abbreviated name for the quantity, such as t for time, or T for temperature.

Click the three dot menu on a row or column to see what options you have:

To clear data from your data table, click the gear icon in the top-left corner of the table. Note that this option will NOT appear to an instructor doing an assignment in Preview mode. It will only appear to students working on the assignment.

Add more columns, and create columns with formulas

If needed, you can add additional columns, or add formulas to columns to do calculations on your data.

Create your Graph

If your graph settings don't look like what you're seeing below, then you'll need to see our help article on our legacy graphing tool.

Once you've got your data collected you can set up your graph, click the gear icon in the top-right to open the graphing menu.

Vertical Axis

  1. Select a column from your data table to plot on the vertical axis

  2. By default, the axis title is the name of the data column. Enter a custom name here if you'd like.

  3. Add additional columns to graph on the vertical axis. Each data set will have a different color and data point icon.

Horizontal Axis

  1. Select a column from your data table to plot on the horizontal axis

  2. By default, the axis title is the name of the data column. Enter a custom name here if you'd like.

Please note: Unlike the vertical axis, only one data column can be graphed on the horizontal axis at a time. If you want to change what's graphed here, select a new column.

Curve Fits

Click the dropdown menu to apply a curve fit function to each data column. You can see the curve fit parameters at the bottom of the graph.

  • The equation for the line will appear below the graph with curve fit parameters A and B

  • "A" represents the slope of the line.

  • "B" represents the y-intercept of the line

  • RMSE stands for Root Mean Squared Error and it tells you how closely the fit matches the data. A lower RMSE generally means a closer fit.

  • To display uncertainty with the fit, check the Display Curve Fit Uncertainty box.

You can click on data points on the graph to include/exclude them from the curve fit calculations.

Graph Settings

  1. By default, the title of a graph is Vertical axis name vs. horizontal axis name. Enter a different name here if you'd like.

  2. Graph your data using a scatter plot, line plot, or bar graph.

View Options

  1. Force the origin to be shown on the graph.

  2. Show the graph legend

  3. Autoscale the axes to minimize extraneous whitespace on the graph.

Customize table and graph settings for your students

Here's how you can customize what settings appear to your students' data table and graphs

  1. Find the activity in your library

  2. Click Edit

  3. Click Activity Content

  4. Find the section with the data table, click to expand it

  5. Find the Data Table and Graph component, click to expand it.

  6. Click Table & Graph Settings

  1. Lets you convert the new data table and graphing interface to our legacy interface.

  2. Allows students to add uncertainty bars to their graph.

  3. Select which curve fits are available to students.

  4. Select which graph types are available to students.

  5. Select which additional options are available to solutions.

Column Statistics

Checking the Column Statistics box allows students to calculate total, median, standard deviation, and mean of a column. They simply need to click Calculate at the bottom of a column and select the value you'd like to calculate.

Using LaTeX in table headers

Students can use LaTeX in table headers to better format variables and expressions.

  1. Click the header you want to edit

  2. Change the Text dropdown to LaTeX

  3. Type in the LaTeX expression

If this feature doesn't appear to students, then the instructor must enable it by editing the activity:

  1. Find the activity in your library

  2. Click Edit

  3. Click Activity Content

  4. Find the section with the data table and click to expand it

  5. Find the data table component and click to expand it.

  6. Click Table & Graph Settings

  7. Check the Show Formula Bar box

  8. Click Confirm

  9. Click Save at the top of the page.

Did this answer your question?