But VBA coding is not that easy to write because it does not require a computer science degree to learn.

Learning and understanding the VBA coding is advisable for creating a well-animated chart.All you need to do is create ideas to design there is no fixed way to create these animated charts. Similarly, we can make different kinds of animated charts, like speedometer charts, circular charts, etc., in Excel with a combination of our normal charts and VBA coding. This is how we will make animated charts in Excel. Now hide the columns “C” and “D” and check. Select the option “Select Data”, then a window will open as below.Ĭlick on the “Hidden and Empty cells” button.Ĭheck the option “Show data in hidden rows and columns”, which will allow hiding the data related to charts. The solution is to click, enabling the “Design” menu on the top as below.

If you hide columns C and D, the chart also will disappear as below. You can observe the car movement from bottom to top depending on the percentage.Įverything looks fine, but we have multiple columns of data visible on the sheet. After completing the program, try to change the value in column B and observe the chart. 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 every value of “I”, VBA will perform an event that is the “I” value divided by 100, and it will store in the same row but in column C, from where our chart takes values with which appearance will change every time. That value will multiply by 100 because the value in the column is in percentage. The meaning of the code is “i” value iterates from zero to a changed percentage value. If both conditions satisfy, we need to perform an event as below. The row should be 2 to 5, so write the below code. If it is column 2, we must check which row it is changing. Once we clear our target rows and columns, we will write the coding below. So, our target is COLUMN B and ROWS 2 to 5. If we observe the data table, the “percentage race completed” column occupies column B and rows 2 to 5. For that, write the below coding.ĭefine a sheet “sh” and assign Sheet 2 to sh as below. But we should write the program to run only when we change a particular data set. The meaning of the code is the program will run whenever we change the data. Select “Change” on the right top then we will get the “Private Sub Worksheet_Change(ByVal Target As Range)” in the coding area. Click on the sheet in which you created the chart.

Download Motiongraph for Xper