Animation Bike chart with Flag

[Nandakumar]

Hi Everyone,


Request your support with the attached presentation slide, for which the data has been taken from Excel.


I have created an animated bike chart where the monthly performance is shown as a bike moving upward, and the budget is represented as a flag.


I need a small correction in the chart: the actual bike should pick up the flag (budget) and carry it forward until December which is attached herewith.


Thank you in Advance

 

[vletm]

Did You follow instructions ... as You wrote Mar 25, 2025 ?

N

Thread 'Bike chart Creation based on monthly data'

Mar 18, 2025

Hi Experts,

I request your kind help in creating a bike chart based on monthly data—Budget vs. Actuals, where one cycle represents the target and the other represents the actuals. Additionally, I would like to learn how to create animation as shown on the website:

https://chandoo.org/wp/biker-on-hill-chart/

I have attached the Excel sheet for your reference.

Thank you for your support!

• Nandakumar
• Replies: 8
• Forum: Discuss Data Visualizations and Charting

 

[troywest]

That sounds like a great visual concept. To have the bike “pick up” the flag and carry it forward, you will likely need to separate the flag into its own animated object and then use motion paths instead of keeping it fixed to the data point. Once the bike reaches the budget position, trigger an animation that attaches the flag to the bike and continues the same motion path through the remaining months. If you share which tool you are using, it would be easier to suggest the exact steps.

 

[Nandakumar]

Hi basic data from excel and animation done in presentation.
Thanks for the input @troywest