please help me to solve this problem
df2=pd.read_excel(âarea2.xlsxâ)
fig_ = go.Figure(layout = go.Layout(paper_bgcolor=ârgba(105,105,105)â,plot_bgcolor=ârgba(0,0,50,0)â))
y1=df2[âPhone call Actionâ]
y2=df2[âDirection Actionâ]
y3=df2[âWeb Site Actionâ]
y4=df2[âTotal Actionâ]
fig_.add_trace(go.Scatter(
x=df2[âDateâ],
y=df2[âPhone call Actionâ],
mode=âlines+markers+textâ,
name=âPhone call actionâ,
text=y1,
textposition=âbottom centerâ,
line=dict(width=0.5, color='rgb(131, 90, 241)'),
stackgroup='one'
))
fig_.add_trace(go.Scatter(
x=df2[âDateâ],
y=df2[âDirection Actionâ],
hoverinfo=âx+yâ,
mode=âlines+markers+textâ,
text=y2,
name=âDirection Actionâ,
line=dict(width=0.5, color=ârgb(111, 231, 219)â),
stackgroup=âoneâ
))
fig_.add_trace(go.Scatter(
x=df2[âDateâ],
y=df2[âWeb Site Actionâ],
hoverinfo=âx+yâ,
text=y3,
mode=âlines+markers+textâ,
name=âWeb Site Actionâ,
line=dict(width=0.5, color=ârgb(170, 247, 212)â),
stackgroup=âoneâ
))
fig_.add_trace(go.Scatter(
x=df2[âDateâ],
y=df2[âTotal Actionâ],
hoverinfo=âx+yâ,
text=y4,
mode="lines+text",
name="Total Action",
line=dict(width=0.5, color='rgb(255, 203, 203)'),
stackgroup='one'
))
fig_.update_xaxes(tickangle=35, tickfont=dict(family=âRockwellâ, color=âblackâ, size=10),showline=True, linewidth=1, linecolor=âblackâ)
fig_.update_yaxes(showline=True, linewidth=1, linecolor=âblackâ)
fig_.update_layout(uniformtext_minsize=8, uniformtext_mode=âhideâ)
fig_.show()