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
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
Adding Fill Under Traces
To make an area plot from a line plot, edit the 'Fill To' attribute in the MODE tab of the TRACES popover.
Here's how the TRACES popover for 'trace 0' looks. Notice 'Fill To' has been set to 'Y=0'.
Here's how the TRACES popover for 'trace 1' looks. Notice 'Fill To' has been set to 'Next Y'.
Optional styling to make your plot prettier
Nice! Now you have your area plot. If you want, you can change the colors and apply smoothing to the lines to get a chart that looks like one at the top of the tutorial.
Here's how your area chart looks before styling.
Here's how the TRACES popover looks with smoothing and the change of colors.
The smoothing button is highlighted in red.
Here's how the AXES popover looks with the axes lines thickened and made white.
Here's how the LAYOUT popover looks with the plot and margin background color changed to grey.
Export & Share
Download an image of your Chart Studio graph by clicking EXPORT on the toolbar.
Your finished chart should look something like this:
To add the Excel file to your workbook, click where you want to insert the picture inside Excel. On the INSERT tab inside Excel, in the ILLUSTRATIONS group, click PICTURE. Locate the Chart Studio graph image that you downloaded and then double-click it. Notice that we also copy-pasted the Chart Studio graph link in a cell for easy access to the interactive Chart Studio version.