Plotly Excel Add-In
#Installation
- Copy the latest file from Packages to the test system. If you are using Windows, download PlotlyPC.xlam. If you are using OSX, download PlotlyMac.xlam.
- Double-click the file (or open it in excel)
- A security prompt will appear with buttons to Enable Macros or Disable Macros. Select the Enable Macros button.
If the security prompt does not allow you to enable macros, then edit your security settings. In Settings go to Security and uncheck the "Warn before opening a file that contains macros" box.
- Excel will load.
#Using the Add-In
- The Plotly Ribbon will be displayed after the View Ribbon as shown below
- Open or create a new WorkSheet.
- Add data in columns that will represent the X and Y data of the Plot.
- Select the Create Plot button
- Enter username, API Key and file name for the plot.
- Select one of the available Chart Types from the drop down
- 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)
- It is possible to add multiple traces. Select the Add Trace button to choose more data
