Upload your Excel data to Plotly's grid
Open the data file for this tutorial in Excel. You can download the file here in CSV format
Head to Plotly
Head to Plotly's Workspace and sign into your free Plotly account. Go to 'Import', click 'Upload a file', then choose your Excel file to upload. Your Excel file will now open in Plotly's grid. For more about Plotly's grid, see this tutorial
Creating the Scatter Plot
Select '3D Scatter Plots' from the
MAKE A PLOT button on menu bar.
Enable the Group By Option and Text Option from the toolbar, and select the headers as shown in the figure. Finally click on Plot Button to generate the plot
Finalizing the Plot
We will now add some style elements to the generated plot.
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.
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
Markers:Go to 'Traces' Popover. Select 'All Traces' from the dropdown, Select '8' from the 'Marker' option.
Colorways:To set a colorway, Go to 'Traces' popover. Select 'All Traces' from the dropdown, and select 'Blues' colorway from the 'Marker Color Pallete' option:
Exporting the final chart
The final plot should look something like this:
You can export the finished plot to embed in the excel notebook. We also recommend adding the Plotly 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.
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 Plotly graph image that you downloaded and then double-click it: