How To Create An Animated Bar Chart (Bar Race) In Python Using Plotly & Excel | Tutorial [EASY] 💻

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this tutorial I will show you, how to create an animated Bar Chart, also known as a Barrace, in Python & Excel by using the library called Plotly.

The data is coming directly from an excel file.
You can do all the changes in the excel file and after running the script again you will have your updated Bar Chart Animation.
The Barrace is also interactive. If you hover over the bars, you will see additional information.
Lastly, the animation will be also saved as an HTML file. Hence, you could also send the animation to your friends & colleagues, who do not even need to have Python installed on their machines.
This tutorial is focusing on beginners in Python. Even you have never written a single line of code in Python, you will be able to have your free animated bar chart by the end of this tutorial.

👉 You can download the code & excel files for FREE here:

👩‍💻 𝗦𝗢𝗨𝗥𝗖𝗘 𝗖𝗢𝗗𝗘:
import pandas as pd
import streamlit as st
import plotly

# Read Data From Excel and store in a variable df [dataframe]

# Store each column in a seperate varibale.
country = df["Country"]
sales = df["Sales"]

# Create Animated Bar Chart and store figure as fig
df,
x=country,
y=sales,
color=country,
animation_frame=date,
animation_group=country,
range_y=[0, 1200],
)

# Save Chart and export to HTML

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?

[verma]

Thanks. Your videos are really easy to follow & very helpful.

[tongaib]

Hallo Sven, this is pretty awesome. Thanks for helping me learn this cool tech #Winning

[Ravi-lnhy]

Hello Sven, Thanks for this interesting tutorial... how can I create secondary axis with line chart in this case...?

[mariaguadalupebarraganorti]

Hi, If I have to save it as a gif, how can I do it? :(

[GolightlyYeni]

Hi, I followed as what you did, but each bar graphs are separated. When one is end and the other starts. The only difference between your codes and mine is the name of x axis.

[sabzuski]

Would you be able to insert this into a streamlit?

[punjaramborhade]

Instead of DATE if time is there say....
10:12 (min:sec)
10:15 (min:sec)
10:20 (min:sec)

then how to modify code
i.e. date =

to what so we can see in similar way


please answer...🙂

[steepehare]

How To Create An Animated Line Chart Race In Python ? Thanks!