Creating Animated Magic Charts In Keynote

You can animate charts in Keynote, showing how data changes over time. If you use animated Bubble Charts in the right way, you can end up with some interesting results.
You can also watch this video at YouTube (but with ads).
Video Transcript: Hi, this is Gary with MacMost.com. Let's look at using Magic Charts in Keynote. 
MacMost is brought to you thanks to a great group of more than 1000 supporters. Go to MacMost.com/patreon. There you can read more about the Patreon Campaign. Join us and get exclusive content and course discounts.
So when you're using Charts in Keynote a static chart may look nice but wouldn't it be great if the chart was actually animated. If you have three dimensional data, that is data that can be shown on a graph but also go through time, then you have the potential to create a really interesting animated chart. These are called Magic Charts. 
So here I have a blank slide in Keynote. I'm going to go to Chart Cube and you can see there's 2D, 3D, and interactive charts. We're going to choose the Interactive Chart. The first kind here. You can see it's a basic chart here and it looks just like a regular chart except that it has got this bar at the bottom. That's what makes it interactive. I can move the Dot here to four different positions. Each of those 4 different positions has different values for the four bars here. If I edit chart data I can see exactly what this looks like. Here I've got Regions 1-4 and that is each bar. I've got months and you can see here at the bottom it says April. So these values here are for April. If I were to move this over to May these numbers change to show the May values. So I have four different sets of values here each one represented in a new column. 
Now this is kind of neat as an interactive chart and you can do these interactive charts in Numbers as well. What is really cool is that in Keynote you can animate. I'm going to go to Animate on the right and I have a chart selected. You could see the build-in shows Magic Chart. I can change it to one of two things. Magic Chart or None. So Magic Chart is the only option for animating a chart. I can set a duration and the rest of it I don't really want to touch if I want this to work right. 
Now let me look at the build order here and I only have this one element in here, it's the Interactive Chart. I can see it starts on Click. If I change it to After Transition it would start going right away. But now I know I need to click in order to start this animation. So I'm going to Play and I'm on this slide. Now a simple click will animate. You could see it go through May, June, and July. The total time was 5 seconds here. So you change the Duration and make it longer if you want to slow things down. 
Here's a more interesting chart. If I look at this one and edit the chart data I've got a lot more data in here and it's real numbers. I've chosen five states and then I have all the years from 1969 to 2009 and population numbers for these five states. So if I were to drag this around you could see I could go to a different year and see the relative populations for each one of these. Now if I want to animate it, just like before, it's actually going to show me something more interesting. You'll see which states are growing, which states aren't, and the relative growth speeds. So I'm going to Play and then I Click, and you can see the years go up. You can see most states growing rapidly and one state growing a little more slowly. So in that example, by using the Magic Chart, you can make a point in your slideshow. Instead of saying that California is growing faster than New York you can actually show it. Of course, when you export from Keynote as a video, this animation will export as well. 
Now when I showed you the interactive charts you saw that they were four kinds. These two are bar charts and this is a scatter, and this is a bubble chart. The bubble chart is actually interesting because bubble charts already show 3 dimensions. There's a vertical and a horizontal dimension as well as the size of the bubble. Then doing interactive, or Magic Chart, you're actually adding a 4th dimension to it. To do that I'm actually going to switch over to Numbers. The great thing about Numbers and Keynote is you can Copy and Paste a lot of things between them. Setting up a good animated bubble chart in Keynote is really difficult with the Edit Data window. But it's a lot easier to do in Numbers and then we can Copy and Paste the result. 
So what we've got here in Numbers is three rows for each state because there are three different values that need to be represented. The horizontal position, the vertical position, and the size of the bubble. So we have x, y, and size for each of these. It took a lot of trial and error that this was the best way to set it up. Now each of these is going to be at the same spot but the size is going to get different. So we'll keep the y values the same. They will all be along the bottom. But the x values lets change to 100, 200, 300, and 400 like that. Then I'll select all of these so I can Copy and Paste them throughout all of the different empty cells here leaving size, or population, alone. Now if I were to select the entire table, do a chart, say Interactive, and do one of these bubble charts here I'm going to Edit Data References and I can select anyone of these. I can say don't share the x values to make them all different. So now everything is setup where California is in a little group, Colorado is in a little group, etc. You could see each one of these is now right where we want it. The y values are always zero. They are always along the bottom. But the x values are actually zero, 100, 200, so each one is spaced here. Then the sizes are going to change for population. So as I move across you can see the sizes for each one of these change. Instead of having them just be in a row like this, each one was somewhere plotted along here. In fact, I'll paste in a bit of ClipArt here, this map of the United States, and I can shrink it down here. Let's move it to the back and put it behind this chart. What would be really cool is if we could position each one of these dots to be over each individual state. 
So what we want to do is set the Axis to 1000 for maximum and zero for minimum and for x the same thing. Just so instead of it automatically changing as we add numbers this is zero to 1000 and zero to 1000 here. Then we can start setting things up. So we can experiment with Numbers. We can set California to 50 and 500. We can see, oh it's up there. Okay. Let's go and change Colorado to say 300 and 400. Then start working on getting that kind of in the center and do that with each one of those. It takes a little work but you eventually get the dots exactly where you want. So now I've got the numbers right here. I kind of do that. I want to select them all, Copy just those lines so it leaves the population, the size, alone. All these are in the right spots no matter what year I'm in the circles are all in the exact same spot. Because you can see here the x and y values of each one are the same all the way across. It's only the size that changes. Now I've got an interactive chart in numbers where I can see any year and the relative sizes of these. Now I can Copy and Paste this. I actually want to Copy the chart and also the background graphic here. So I grab both. I've got two things. Copy it and then go to Numbers and then go to Keynote and we will Paste it here. You can see it pulls it across really nicely. So I can select the interactive part here and it is still working. I can select the chart itself. Edit chart data and you can see all of those numbers are in here just like they were. It would have been really hard to get them in there in Keynote. But it is easier to do in Numbers. 
I could still work with the chart here under Format to do things like, you know, let's get rid of the axis lines and the values and major grid lines here on the y value can be gotten rid of. So you eventually get rid of all the different things you don't need. Unfortunately the year is black text on black. So what you probably want to do here for this slide is change its color fill to something else like that. So now you can see that. Now if I select the chart and go into Animate I can make sure I have Magic Chart turned on. When I play this slide here it shows me the map with the dots. 1969. I click and you can see the years roll forward and the dots change size. 
Now the first technique I showed you using the simple column chart there is super easy to do and you should be able to do it relatively easily just there in Keynote. This technique here takes a lot of trial and error to get the numbers just right. Make sure you've got everything working just like you want in Numbers before you Copy and Paste over into Keynote. 
Hope you found this useful. Thanks for watching.
Creating Animated Magic Charts In Keynote

Comments: One Response to “Creating Animated Magic Charts In Keynote”

Welcome to MacMost

Free Weekly Newsletter

MacMost Online Courses

Keyboard Shortcuts PDF

Connect with MacMost

MacMost Sections

Popular Tutorials

Information
