fbpx
Search
Close this search box.

CP048: How to create animated charts in Excel?

Share

Facebook
Twitter
LinkedIn

In the 48th session of Chandoo.org podcast, let’s make some animated charts!!!

session-048

What is in this session?

In this podcast,

  • Announcements
  • Why animate your charts?
  • Non-VBA methods to animate charts
    • Excel 2013’s built-in animation effects
    • Iterative formula approach
  • VBA based animation
    • Cartoon film analogy
    • Understanding the VBA part
  • Example animated chart – Sales of a new product
  • Resources and downloads for you

Listen to this session

Click here to download the MP3 file.

Resources for making animated charts

Example animated chart (shown in the title image):

Download example animated chart. Play with it to learn more.

More animated charts using Excel:

VBA Basics:

Non-VBA animation using formulas:

Animation without macros [for fun]

 

Transcript of this session:

Download this podcast transcript [PDF]

How do you create animated charts in Excel?

Now it’s your turn. Do you make animated charts? Please share your techniques and samples in the comments section. Wow us.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Weighted Average in Excel with Percentage Weights

Weighted Average in Excel [Formulas]

Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.

What is weighted average?

Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”

Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.

20 Responses to “CP048: How to create animated charts in Excel?”

  1. Raj says:

    Hi Chadoo,
    Awesome chart. I am really wondering from where are you getting such innovative ideas.

    Raj

  2. Satya says:

    thanks for the informative podcast on Charts animation!
    it helped a lot to me.

    (based in VSKP, India)

  3. Manoj jain says:

    Thanks for this information.Very nicely explained

  4. Sai ram says:

    Hi Chandoo,

    Very useful information , it helps alot for presentations..

    CP048(based In hyderabad, India)

    • Pavan says:

      Hello Chandoo,

      This is really superb...As you always say, with these kind of tips and tricks you make us awesome...Your knowledge being "lent" to us in "Excel" will definitely make us "Excellent" 🙂

      CP048(Hyderabad, India).

  5. Vinay Soni says:

    Hi Chandoo,

    This info of animated charts is Awesome, very useful.

    (Based in Mumbai, Mulund)

  6. StarInfranet CEO Anand Mishra says:

    Hey Chandoo,

    Thanks for sharing the info, keep up the good work going.... I really enjoyed exploring your site. good resource..

  7. Rana Ahammed says:

    Hi Chandoo,

    This tutorial regarding animated charts is Awesome &very useful.

    But My macro Not working.

    It show a debug msg on size= 12 * [scale] line.
    Note: my step is 7.

    Can you please explain me briefly regarding this?

    Option Explicit

    Sub animate()
    Dim i As Long
    Dim size As Long

    size = 12 * [scale] (Problem is here)

    For i = 0 To size
    [step] = i / [scale]
    DoEvents
    Next i

    End Sub

  8. Arvind says:

    Dear Chandoo,

    This is Arvind from Mumbai. Post my enrollment with your course and hearing on Iphone Podast, this (CP048) is really superb. As you always say, with these kind of tips and tricks you make us awesome. I am applying your thought process in other areas of life as well which would make awesome over there also.

    God Bless you as you have been enriching our life in excel.

    Thank you,
    Arvind Jain

  9. Rahul says:

    Hi Chandoo,

    I am a avid follower (more of a fan of the mighty Excel and your expertise).

    I use the resources and knowledge of this blog very frequently. Always a treat to visit your site / blog / resources.

    Baroda / Vadodara, India

  10. Jimmy says:

    Hi Chandoo,

    Based out of India, looking forward to the new book.

    All the best with the sales. And keep up the great job.

    Cheers!

  11. Arun says:

    Hi Chandoo,

    I was watching all your videos in You Tube channel. First time listened podcast session CP048. I'm from India Bangalore if possible please share the book. It will be very useful for professional growth.

    You are so innovative and your helping tendcy by sharing the knowledge is very useful for me.

    Thanks, Arun

  12. Chandoo says:

    Thanks everyone for the comments and love.

    Congratulations to the 3 random winners - Satya, Pavan and Arvind. You will get your book shortly.

  13. Mangirish Nadkarni says:

    Hi Chandoo,

    I am from India and I was looking for this. Thanks for sharing a very valuable and useful info. I see the winners for the book are already decided. But I would surely buy this book.

  14. savithri says:

    Hello Chandoo

    I need to mention this. Thanks for making me really awesome in excel and your great techniques. What ever comments I get at workplace would like to dedicate to you.

    Heard your podcast video. Thanks for sharing and I would like to get the book as well. Where can I get it?

    Thanks
    Savithri

  15. Wunmi says:

    Really helpful podcast. Simply listening to you speak on this topic helped me get the concept behind animating charts. Thanks!

  16. Praveen says:

    Hi Chandoo,

    I am based out of Bangalore. I am so curious about your podcast its really interesting. Please let me know where I can get the book.

    Thanks & Regards,
    Praveen Kumar

  17. Momty says:

    Superb topic...loving it...Am from india

Leave a Reply