import plotly
plotly.__version__

import plotly.offline as py
import plotly.graph_objs as go
py.init_notebook_mode(connected = False)

trace = go.Waterfall(
    name = "20", orientation = "v", 
    measure = ["relative", "relative", "total", "relative", "relative", "total"], 
    x = ["Sales", "Consulting", "Net revenue", "Purchases", "Other expenses", "Profit before tax"], 
    textposition = "outside", 
    text = ["+60", "+80", "", "-40", "-20", "Total"], 
    y = [60, 80, 0, -40, -20, 0], 
    connector = {"line":{"color":"rgb(63, 63, 63)"}}, 
)

layout = go.Layout(
        title = "Profit and loss statement 2018", 
        showlegend = True
)

py.iplot(go.Figure([trace], layout), filename = "basic_waterfall_chart")

import plotly.offline as py
import plotly.graph_objs as go
py.init_notebook_mode(connected = False)

trace1 = go.Waterfall(
    x = [["2016", "2017", "2017", "2017", "2017", "2018", "2018", "2018", "2018"],
        ["initial", "q1", "q2", "q3", "total", "q1", "q2", "q3", "total"]],
    measure = ["absolute", "relative", "relative", "relative", "total", "relative", "relative", "relative", "total"],
    y = [1, 2, 3, -1, None, 1, 2, -4, None],
    base = 1000
)
trace2 = go.Waterfall(
    x = [["2016", "2017", "2017", "2017", "2017", "2018", "2018", "2018", "2018"],
        ["initial", "q1", "q2", "q3", "total", "q1", "q2", "q3", "total"]],
    measure = ["absolute", "relative", "relative", "relative", "total", "relative", "relative", "relative", "total"],
    y = [1.1, 2.2, 3.3, -1.1, None, 1.1, 2.2, -4.4, None],
    base = 1000
)

layout = go.Layout(
    waterfallgroupgap = 0.5,
    xaxis = {"title":"MULTI-CATEGORY","tickfont":{"size":16},"ticks":"outside"}
)

data = [trace1,trace2]
fig = go.Figure(data, layout)
py.iplot(fig,filename = "mutli_category_waterfall")

import plotly.offline as py
import plotly.graph_objs as go
py.init_notebook_mode(connected = False)

trace = go.Waterfall(
    x = [["2016", "2017", "2017", "2017", "2017", "2018", "2018", "2018", "2018"], 
       ["initial", "q1", "q2", "q3", "total", "q1", "q2", "q3", "total"]], 
    measure = ["absolute", "relative", "relative", "relative", "total", "relative", "relative", "relative", "total"], 
    y = [10, 20, 30, -10, None, 10, 20, -40, None], base = 300, 
    decreasing = {"marker":{"color":"Maroon", "line":{"color":"red", "width":2}}}, 
    increasing = {"marker":{"color":"Teal"}}, 
    totals = {"marker":{"color":"deep sky blue", "line":{"color":'blue', "width":3}}}
)

layout = go.Layout(
    title = "Profit and loss statement", 
    waterfallgap = 0.3, 
    xaxis = {"title":"", "tickfont":{"size":15}, "ticks":"outside"}
)

py.iplot(go.Figure([trace], layout), filename = "Style_waterfall")

import plotly.offline as py
import plotly.graph_objs as go
py.init_notebook_mode(connected = False)

trace = go.Waterfall(
    name = "2018", orientation = "h", measure = ["relative", "relative", "relative", "relative", "total", "relative", 
                                              "relative", "relative", "relative", "total", "relative", "relative", "total", "relative", "total"], 
    y = ["Sales", "Consulting", "Maintenance", "Other revenue", "Net revenue", "Purchases", "Material expenses", 
       "Personnel expenses", "Other expenses", "Operating profit", "Investment income", "Financial income", 
       "Profit before tax", "Income tax (15%)", "Profit after tax"], 
    x = [375, 128, 78, 27, None, -327, -12, -78, -12, None, 32, 89, None, -45, None], 
    connector = {"mode":"between", "line":{"width":4, "color":"rgb(0, 0, 0)", "dash":"solid"}}
)

layout = go.Layout(
    title = "Profit and loss statement 2018<br>waterfall chart displaying positive and negative", 
        yaxis = {"type":"category", "autorange":"reversed"}, 
        xaxis = {"type":"linear"}, 
        margin = {"l":150}, 
        showlegend = True
)

py.iplot(go.Figure([trace], layout), filename = "horizontal_waterfall")

from IPython.display import display, HTML

display(HTML('<link href= "//fonts.googleapis.com/css?family= Open+Sans:600,400,300,200|Inconsolata|Ubuntu+Mono:400,700" rel= "stylesheet" type= "text/css" />'))
display(HTML('<link rel= "stylesheet" type= "text/css" href= "http://help.plot.ly/documentation/all_static/css/ipython-notebook-custom.css">'))

! pip install git+https://github.com/plotly/publisher.git --upgrade
import publisher
publisher.publish(
    'waterfall-charts.ipynb', 'python/waterfall-charts/', 'Waterfall Charts',
    'How to make waterfall plots in Python with Plotly.',
    title= 'Python Waterfall Chart | Plotly',
    has_thumbnail= 'true', thumbnail= 'thumbnail/waterfall-charts.jpg',
    language= 'python',
    # page_type= 'example_index', // note this is only if you want the tutorial to appear on the main page: plot.ly/python
    display_as= 'basic', order= 6.2, ipynb= '/~notebook_demo/276',uses_plotly_offline= True)