• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Bike chart Creation based on monthly data

N

Nandakumar

Member
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!
 

Attachments

  • biker-on-hill_Chandoo22Mar18.xlsx
    151.3 KB · Views: 7
Should I read that You skipped its instructions?
Have You done any changes to Your file?
What is missing?
 
The animation is not part of the exercise. The author probably entered data and comments representing each frame of the animation, took a screenshot, and compiled the screenshots into a gif.
 

Nandakumar​

So, Your skipped to read those instructions.
>> Add data in 'Completed'-column one-by-one and You'll get Your animation step-by-step.
If You've all Your data - You could control 'Completed'-column eg with ScrollBar.
 
Jon Peltier MVP said:
The animation is not part of the exercise. The author probably entered data and comments representing each frame of the animation, took a screenshot, and compiled the screenshots into a gif.
Click to expand...
Dear Jon,
As I'm the source of inspiration Chandoo talks about, I can tell the animation is part of the exercise, controlled with a spin button form controls. With a data feeder, or a dynamic data connection, it can animate on it's own.
The gif is a simple screen recording, not about sequenced screenshots.
 
You must log in or register to reply here.
Back
Top