As the charts stands (see previous image), it has a lot of information to impart.
We need to bring portions of the chart to the attention of the audience in small doses. This way, we maintain audience focus and improve comprehension.
Animating the Top Chart
Select the first chart (top) and switch to the Animations tab.
Although you can select any animation you wish, I find that when working with column charts, the Wipe effect is visually effective.
The Wipe effect gives the chart the illusion that the bars are “growing” out of the horizontal axis.
The default effect is to bring in the entire chart as a single object. We will change that setting by clicking Animations (tab) -> Animation (group) -> Effect Options -> Sequence -> By Series.
Remember that the first series in our chart are the gray bars and the second series are the green bars.
Animating the Bottom Chart
Select the second chart (bottom) and apply the Appear animation to the chart.
As with the Wipe effect used earlier, the entire chart appears in a single instance. We want each data point to appear one after the other. Select a bar in the lower chart and set the Effect Options to animate By Category.
This setting gives us the flexibility to bring each data point onto the screen in time with the telling of our story.
Since many of the data points contain little change, we want to focus on the countries with the most change (i.e. USA and India.)
We have two main adjustments to apply:
- modify the data points for USA and India to have a Wipe effect, leaving the remaining countries as Appear
- make the data points with little change appear at once. We will make an adjustment to the animation sequence of the countries Canada, Germany, China, and Brazil so they appear as a singe block of data points.
Activate the Animation Pane by selecting Animation (tab) -> Advanced Animation (group) -> Animation Pane.
Expand the animation list for the second chart (double down arrows) to reveal the individual animations.
NOTE: There is limited room to display the names of the chart elements. If you are unsure as to which object in the animation list applies to which object in the chart, you can hover over a list item to see the complete name of the associated chart object.
We will use the animation sequence numbers when reference items in the list (ex: 5 = USA and 10 = India.)
Select USA (sequence number 5) and set the animation effect to Wipe.
Next, change the direction of the Wipe effect for USA (sequence number 5) by changing the Effect Option from From Bottom to From Top. This adjustment is useful because USA has a large negative variance.
For the next four countries, because there is little difference between them, and their amounts are small, we want them to appear simultaneously.
Select sequence numbers 7, 8, and 9 (Germany, China, and Brazil) and set the Start option to With Previous. This will cause those 3 bars to appear when Canada’s data point (sequence number 6) appears.
Select sequence number 10 (India) and set the animation effect to Wipe. The default wipe direction is From Bottom which will work well for positive values.
The result should appear as follows: