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.