Intro to Plotly

Interactive charts

Plotly Express

Charts from a pandas DataFrame, saved as one HTML file.

requirements.txt

xlwings

pandas

plotly

Restart xlwings Lite after saving

px.bar

px.line

px.scatter

px.pie

px.area

px.histogram

All chart types plotly.com/python/plotly-express

Pass the DataFrame, point at columns

DataFrame (df)

Distributor_Name	Region	Commission_USD
Anna Schmidt	EU	1,234
Joao	LATAM	980
Yumi	APAC	2,100
Mateus	NAM	1,560

Python

# build the chart
fig = px.bar(
  df,
  x="Commission_USD",
  y="Distributor_Name",
  color="Region",
  orientation="h",
)
fig.write_html("chart.html")

Try it yourself

Hover for values Click legend to filter a region Drag to zoom in