excel-plugin

Plotly Excel Add-In

---

#Installation

1. Copy the latest Plotly.xlam file from from Packages to the test system
2. Double-click the file (or open it in excel)
3. A security prompt will appear with buttons to Enable Macros or Disable Macros. Select the Enable Macros button.

4. Excel will load.

#Using the Add-In

1. The Plotly Ribbon will be displayed after the View Ribbon as shown below

2. Open or create a new WorkSheet.
3. Add data in columns that will represent the X and Y data of the Plot.
4. Select the Create Plot button

5. Enter username, API Key and file name for the plot.
6. Select one of the available Chart Types from the drop down

7. Select one of the available columns to represent the X and Y data (Note that for Box Plot and Histogram, only 1 column of data is required)

8. It is possible to add multiple traces. Select the Add Trace button to choose more data