EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Excel Animation Chart
Secondary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course

Excel Animation Chart

By Madhuri ThakurMadhuri Thakur

Excel Animation Chart

Excel Animation Chart (Table of Contents)

  • Definition of Animation Chart in Excel
  • Example of Animation Chart in Excel

Introduction to Animation Chart in Excel

The charts that illustrate the data in an animated and dynamic way to better understand the charts are called animation charts. The animation charts require a little additional effort and knowledge of macro to create dynamic changes and movements in the chart.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

To create an animation chart, we first need to create a normal chart for which we will add little coding to make it an animated chart. So, one should have knowledge of VBA coding to understand and create the animated charts. It is not mandatory to use coding for animated charts if you are good at creative thinking; you can also make it without VBA coding.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,325 ratings)

Example of Animation Chart in Excel

Here I am covering an example of percentage completion of race by a car. Follow the below steps to create the animated chart. First, create a small table layout for race details with racer name and percentage of Race completed as shown in the below picture.

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

Excel Animation Chart 1-1

Enter the data related to the percentage of the race completed in “column B” if you want to input 60 percent input as 0.6 and then cntrl+shift+% symbol on the keyboard to convert to a percentage.

Excel Animation Chart 1-2

Now add another two columns as below and input the same data as column B. I know it may create confusion for you; it will clear once we create the chart.

Excel Animation Chart 1-3

Hide column B.

Excel Animation Chart 1-4

Select only visible data by clicking on Alt+; click on the Insert option, then choose 2D columns, which are highlighted in the red color box.

Excel Animation Chart 1-5

Select the Stacked Bar Chart below.

Excel Animation Chart 1-6

Excel Animation Chart 1-7

Now we will remove all the percentages, chart title and Legends by clicking on the plus symbol.

Excel Animation Chart 1-8

Deselect all the checkboxes below.

Excel Animation Chart 1-9

Click on right-hide on a chart, then select Format Data Series.

Format Data Series

Now double click on the percentage completion part and choose Gradient fill on the right-hand side, as shown below. We can change the color as per our requirements.

Gradient Fill

Now choose the car percentage that is orange part of the chart as below.

Gradient Fill 1

Choose a car picture from Google or copy a car picture that you have in your desktop images and paste it on the orange part; then, the map looks like below.

car picture

The design part of the chart is completed. Now, we need to complete the VBA coding to create movements to the cars when we ever change the percentage of completion of the race in the data table.

Click on the Developer tab and then click on the visual basic in the left-hand corner.

deveolper tab -Visual Basic

Click on the sheet in which you created the chart. Here my chart is in sheet 2.

visual basic code

Select “Change” on the right top then we will get the “Private Sub Worksheet_Change(ByVal Target As Range)” in the coding area. The meaning of the code is, the program will run whenever we change the data. But we should write the program to run only when we change the particular set of data. For that, write the below coding.

Define a sheet “sh” and assign Sheet2 to sh as below.

Worksheet

Define an integer as below.

Dim Integer

If we observe the data table, the “percentage race completed” column occupies column B and rows 2 to 5. So, our target is COLUMN B and ROWS 2 to 5.

Race Completed size

Once we clear about our target rows and columns, we will write the below coding. Check if the change is in column 2.

IF target

If it is column 2, then we need to check which row it is changing. The row should be 2 to 5, so write the below code.

IF target 1

If both the conditions satisfy, we need to perform an event as below.

Excel Animation Chart 1-8

The meaning of the code is “i” value iterates from zero to a changed percentage value. That value will multiply by 100 because the value in the column is in percentage. After every value of “I”, VBA will perform an event that is “I” value will divide by 100, and it will store in the same row but in column C, from where our chart is taking values with which appearance will change every time.

That means whenever we change the value in the percentage completion column, the value in column C starts from Zero and goes until the changed value(new value). After completion of the program, try to change the value in column B and observe the chart. You can observe the car movement from bottom to top depending on the percentage.

Racer name

Everything looks fine, but we have multiple columns of data is visible on the sheet. If you hide columns C and D, the chart also will disappear as below.

Racer name 1

The solution for this is to click, which will enable the “Design” menu on the top as below.

Selecting Data

Select the option “Select Data”, then a window will open as below.

Select Data Source

Click on the “Hidden and Empty cells” button.

Hidden and empty rows

Check the option “Show data in hidden rows and columns”, which will allow hiding the data related to charts. Select Ok here.

Race Completed support

Now hide the columns “C” and “D” and check.

% race completed

This is how we will make animated charts in excel. Similarly, we can make different kinds of animated charts like speedometer chart, circular charts, etc., in excel with the combination of our normal charts and VBA coding. All you need to do is creative ideas to design; there is no fixed way to create these animated charts.

Things to Remember

  • It is advisable to learn and understand the VBA coding to create a well-animated chart. But VBA coding is not that easy to write at the same to it does not require a computer science degree to learn.
  • Whenever creating an animated chart, try to keep it simple and clear because too much animation on unimportant data items also requires more coding or working may spoil the actual meaning.
  • Create the chart that apt for your data representation because every chart is not suitable for all situations. A wrong selection of chart may restrict you to represent a limited amount of data.
  • Don’t forget to save excel with Macro enabled workbook when you use VBA coding.

Recommended Articles

This is a guide to Excel Animation Chart. Here we discuss how to create excel animation chart along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Checklist in Excel
  2. 3D Scatter Plot in Excel
  3. Radar Chart in Excel
  4. Surface Charts in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Excel for Marketing Training (8 Courses, 13+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formulas, charts, formatting creating excel dashboard & others

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Animation Chart Excel Template

EDUCBA

Download Animation Chart Excel Template

EDUCBA

डाउनलोड Animation Chart Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more