Skip to content

Latest commit

 

History

History
46 lines (24 loc) · 1.67 KB

README.md

File metadata and controls

46 lines (24 loc) · 1.67 KB
Raw

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.

"Security prompt"

  1. Excel will load.

#Using the Add-In

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

"Create ribbon"

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

"Create Plot form"

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

"Select Chart type"

  1. 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)

"Select data column"

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

"Select Add Trace"