WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Animation Chart in Excel

Animation Chart in Excel

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Animation Chart

When the chart itself can convey the message so beautifully, how about adding animation to the chart! Animation? Yes, we can add animation to the charts that we create.

Chart Animation requires complete VBA knowledge, and master that advanced VBA skills are not a walk in the park; it requires special dedication in learning those coding skills. Feeding your VBA animation chart is too much to digest at the moment, so we will show you how to create animated charts in excel without VBA coding. Read on.

Charts are like a beautiful garden in the city, and adding animation to the chart is the lovely flower in the garden. Telling the story behind the data through animation goes a long way in holding on to the user’s attention for a long time. Static charts are just enough to convey the message without any suspense but adding animation to the chart just good enough to play with the emotions of the audience.

Animation-chart

How to do Animation in Excel Chart?

Let’s build the Animation Chart with excel without the help of VBA coding.

You can download this Animation Chart Excel Template here – Animation Chart Excel Template

For this animation, I have created the below data.

animation chart example 1.1

With this data, we will build an animated chart in excel to show each quarter.

The first thing we need to do is to insert a column chart in excel for this data.

animation chart example 1.2

After inserting the chart, we need to insert “Option Button” from the Developer tab Excel.

animation chart example 1.3

Draw this option button on the chart.

animation chart example 1.4

Edit the text and enter the text as “All Quarter.”

animation chart example 1.5

Right-click on the Options Button and choose “Format Control” or you can press Ctrl + 1 to open the “Format Control.”

animation chart example 1.6

Select “Unchecked” and give “Cell Link” to A14 cell.

animation chart example 1.7

Press Ok. We will have our first Option Button ready.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

animation chart example 1.8

As you can see in the above image, “Option Button” is unchecked, and cell link A14 shows 0. If I check, the Option Button value in A14 becomes 1.

animation chart example 1.9

Like this, insert four more option buttons and name them as “Q1”, “Q2”, “Q3”, and “Q4” respectively.

animation chart example 1.10

Note: Give a cell link to the same cell, i.e., A14 cell.

If the first Option Button is checked, then cell A14 value will change to 1; if the second Option Button checked, then cell A14 value will be 2; for the third Option Button, it will change to 3 and so on…

Now we need to set up the data to show each quarter sales separately. Create a replica of the data table to the right and add a new column as “Quarter.”

animation chart example 1.11

Now in the Quarter column, we need to enter some formula to capture the data based on the “Option Button” selection we make.

Jan, Feb, and Mar will be the first quarter, so we need to insert the below formula.

animation chart example 1.12

I have mentioned the IF formula in excel; based on the “Option Button” selection, it will reflect the data. If the Q1 option button is selected, it will reflect Jan, Feb, and Mar month numbers, or else it will reflect the #NA value.

Now for Q2 from Apr to Jun, we need to change the logical condition from 2 to 3.

animation chart example 1.13

If the Q2 Option Button clicked, this formula shows numbers for this quarter. Similarly, now for Q3 & Q4, we need to enter a formula.

For Q3 enter the formula as =IF($A$14=4,E8,NA())

And for Q4 enter the formula as =IF($A$14=5,E9,NA())

Now with this rearranged data, we need to add data series to the existing chart.

Right-click on the chart and choose “Select Data.”

Example 1.14

In the below window, press on the “Add” button.

Example 1.15

In the Edit Series window, choose F1 for Series Name, and for Series Values, choose Quarter column values.

Example 1.16

Click on Ok, and we will have a chart like the below.

Example 1.17

Now select the column bars and press Ctrl + 1 to format the data series option.

Example 1.18

In the “Format Data Series” window, make series overlap as 100%.

Example 1.19

Now select the bar and make the color as “Light Green” for all the bars.

Example 1.20

Now for Quarter Series, fill with orange. We cannot see the impact immediately.

Example 1.21

Ok, we are done with the formatting, now select the Q1 Option Button and see the magic.

Example 1.22

As I have selected the Q1 Option button and Q1 months data has been highlighted with orange.

Like this, without using VBA, we can create animation charts in excel.

Animation GIF

Things to Remember

  • Using VBA code is the advanced way of creating an animated chart but requires extensive coding language.
  • This is a simple example we can create a wide variety of animation charts without the help of VBA.
  • Using form controls in excel like checkbox, spin button, option button, we can still create an animate chart without the help of VBA.

Recommended Articles

This has been a guide to Animation Chart in Excel. Here we discuss how to animate an excel chart without VBA coding with the help of an example. You can learn more about excel from the following articles –

  • What is Step Chart in Excel?
  • How to Insert Watermark in Excel?
  • Histogram Chart in Excel
  • Sparklines in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Animation Chart Excel Template

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More