Become Awesome in Excel by Chandoo.org - A podcast aimed to teach you data analysis, charting, visualization, dashboard reporting, big data analysis, Power Pivot, Self-service BI, Excel based spreadsheet-modeling, automation thru VBA, macros, project management, business analysis, interactive & dyanmic graphs, pivot tables, Excel formulas, functions, calculations, summarizing data, Excel formatting, shortcuts, productivity, application development, beginner to advanced Excel skills, excel tips, techniques, tutorials and templates. We do this by providing you with spreadsheet design strategies & tactics, Excel tips, keyboard shortcuts, productivity hacks, case studies, personal experiences, interviews with Excel authors & Microsoft MVPs, book & product reviews related to Excel and answering your Excel questions & doubts.
https://chandoo.org/wp/category/podcast/
CP048: How to create animated charts in Excel?
In the 48th session of Chandoo.org podcast, let’s make some animated charts!!!
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
Click here to download the MP3 file.
Resources for making animated chartsExample animated chart (shown in the title image):
Download example animated chart. Play with it to learn more.
More animated charts using Excel:
- Diwali flower pot cracker using animated charts
- Another Diwali animated chart in Excel
- Journey of Hurricane Sandy – Animated Chart
- 3D Dancing pendulums using Excel Charts & VBA
- Designing a clock using Excel
VBA Basics:
- Podcasts:
- Introduction to VBA – CP022
- Using FOR Loops in VBA – CP039
- Articles:
- Introduction to VBA – 5 part tutorial
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.
The post CP048: How to create animated charts in Excel? appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.