Show Sidebar Hide Sidebar

Make a 3D Line Plot Online with Chart Studio and Excel

3D Line Plots with Chart Studio

Step 1

Upload your Excel data to Chart Studio's grid

Open the data file for this tutorial in Excel. You can download the file here in CSV format

Open data in excel

Step 2

Head to Chart Studio

Head to the Chart Studio Workspace and sign into your free Chart Studio account. Go to 'Import', click 'Upload a file', then choose your Excel file to upload. Your Excel file will now open in Chart Studio's grid. For more about Chart Studio's grid, see this tutorial

Import data

Step 3

Creating the Line Plot

Select '3D Line Plot' from the MAKE A PLOT button on menu bar.

Select Chart Type

Select the columns to be used as x, y and z axes for line plot. Click on '3d line plot' to generate the chart

Create Chart

Step 4

Finalizing the Chart

The chart looks like the one shown below:

Raw Plot

We are going to add some style elements to the chart. Styling options are present on the left side of the plot. To set the background color, (1) Click on the 'Axis' selector on the options menu on the left side of the plot, (2) Click on the 'Lines' tab from the pop-up, (3) Set 'Background' to 'On', and (4) Select background color from the color pallete.

Background Color

Axes and Grid: Go to 'Lines' tab from 'Axis' Selector. (1) Set Grid Lines to 'On' and select white color from pop-up, (2) Set Zero Lines to 'On' and select white color from pop-up

Set Axes and Grid Color

Step 5

Exporting the final chart

The final plot will look something like this:

Finished Plot

You can export the finished plot to embed in the excel notebook. We also recommend adding the Chart Studio link to the excel for easy access to the interactive version. To get the link to the chart, click on the 'Share' button. To export the chart, as an image, click on 'EXPORT' button on the toolbar.

Share Button

To add the Excel file to your workbook, click where you want to insert the picture inside Excel. On the INSERT tab inside Excel, click PICTURE. Locate the Chart Studio graph image that you downloaded and then double-click it:

Excel