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 Chart
After importing the data, select the 'heatmaps' option from 'Choose Plot Type' dropdown.
Select 'Z Matrix' as the data shape, click on 'Select all columns', and then on the 'Make Heatmap' button to create the plot.
This will create a heatmap chart using the data. To convert the heatmap to a contour plot, we need to select 'Contour map' from the TRACE popover, as shown in the figure below.
Optional styling of the plot
We should have a contour plot created like the one below. Now we are going to style it to make it more presentable.
In the 'Traces' popover, under the 'style' tab, toggle 'auto-color' to off, and then select one of the styles from the list below.
This is how the final chart looks like!
Export & Share
You can also export a static image of your plotly graph. Download an image of your Plotly graph by clicking EXPORT on the toolbar.
To add the chart inside an excel sheet, click where you want to insert the picture inside Excel. On the INSERT tab inside Excel, in the ILLUSTRATIONS group, click PICTURE. Locate the Plotly graph image that you downloaded and then double-click it.