Show Sidebar Hide Sidebar

How to Enter Data in the Grid

A Step by Step Guide to Entering Data in the Grid

How to Enter Data in the Grid

Step 1: Set up the Grid

The first step to making any Plotly graph is setting up the data in a grid. You can type your data directly into a grid, or copy it from a spreadsheet and paste it in.

Open a + NEW GRID from the file well. New grid
Type directly into the cells, or type “ctrl-v” to paste in clipboard content. Type or paste content
Click the Save icon and give it a name, then choose your Sharing Settings or just click Close. It will be saved to your Workspace under My files for future plots and to share it. Name and save grid !New grid in workplace](/static/images/enter-data-in-the-grid/new-grid-in-workplace.png)

You can import .csv, .xls, or .xlsx files directly into Plotly. Additionally, you can import data from Google Drive and Dropbox.

Upload a file using the IMPORT tab. Import from Google Drive File upload
If you upload a workbook, a new grid will be created for every sheet within the book… New sheets in workspace
…they’re all stored in a folder named after your file in the filewell. Filewell

View Data You can extract the data from any Plotly graph, and build your own graph out of it!

Go to any graph page. The one pictured to the right is https://plot.ly/~slkent/51. Click the DATA button, located in the lefthand sidebar, to view the data. To load the data in your workspace, click on Fork and edit. Fork and edit
Click the VIEW DATA button, located in the toolbar, to view the data. View data
…the column names should let you know what role they played in the original plot. Column names
Save and name your new data set and save it to the filewell, to have it on-hand for future plots and to share it. Save data to filewell

Step 2: Plot

Once your grid is set up, you’re ready to plot!

Select your plot type from the MAKE A PLOT menu. Select plot type
Click the OPTIONS you’d like to enable in the sidebar… Enable options in sidebar
…then set your variables with the buttons that have appeared below the column headers… Set variables
…different colors indicate different data sets. These will be plotted as different colors by default. Different colors for different data sets
Click the PLOT button at the bottom of the sidebar to make your plot. You can either make a new plot (default) or add to an existing one. Click plot button
Still need help?
Contact Us

For guaranteed 24 hour response turnarounds, upgrade to our Premium or Enterprise plans.