- [Neil] Hey, everybody, Neil
Malek with Knack Training,
bringing another everyday Office video.
And in today's video,
I'd like to demonstrate
this effect right here.
So as you can see, I've
got a normal slide.
On the right side of the slide,
I have the piece of the pie chart
or the doughnut chart here is clickable.
And when I click on it, it
takes me to a version of this
where the right-hand
side is now broken down.
And what's further,
if I go over here to this
little wedge of the pie,
I can see I got a little hand
here, and I can click on it
and I can expand out the information
about that specific wedge of pie.
I can click back on it, click on it again,
click on it again, and
expand it and contract it.
And then if I click on the left side,
the other simple side of the chart,
then the right side of the
chart becomes simplified again,
the left side of the
chart becomes broken down.
And if I want to isolate
one specific value,
again, I can click on it,
and it expands and contracts the labeling
for that part of the chart.
I can do this with just a little bit
of breaking the chart down
into its component pieces,
hyperlinks, and triggered animations.
So let me go ahead and
show you how it's done.
As you can see here,
in PowerPoint I'm going
to have three slides,
one that is simple,
one that is the right side broken down
with a little labeling.
If I wanted to do labels
for all of them, I could,
but that's just exhausting for
the purposes of the tutorial,
so I only did one of 'em.
And then slide number
three, as you can see,
the broken down left side of the chart
with just the one label on it.
Okay, so now let's go ahead
and make a new blank slide here
and start off with my
simple version of the chart.
Now, I went ahead and made
all these charts in Excel.
You could just as easily
make them in PowerPoint,
but I'm a fan of working
in Excel when I can.
Notice the basic idea here.
What I have is let's say
they're survey results
or types of people who attended an event.
And I've broken them down into people
who are C-level executives
and people who are
director-level managers.
And I've gone ahead and sorted it
so all the executives
are up here at the top
and all the directors are
down here at the bottom.
And this little doughnut
chart has every one
of the segments in it.
Then over here on the right, I just said,
yeah, some of these people are executives
and some of them are directors.
And what I'll do is I'll
use the SUMIFS function
to add up the number column
whenever the information
in the level column
matches up with executive.
And in the same way here for director,
whenever you see the
number in the number column
where the level is set to director,
go ahead and add those together.
And again, the reason why
sorting the executives together
was so important is because
right here at the end of Other,
that's this little wedge right down here.
This is the other executive values.
And you can see that
that matches up perfectly
with the simple version
of the chart on the right.
Okay, so I click on the
chart on the right, copy it,
come over here to
PowerPoint, and paste it.
And I'll take it a second here,
leave it as a chart for the time being,
but just click on the
right side of the chart
and use Control + 1.
And I just like to make this
a little bit cosmetically different.
So I'll go over here and fill it let's say
with dark green like I did in the example.
And then click on the
left side of the chart
and make that sort of a softer green.
Great.
Now, the next part of this
is that in order for us
to be able to click the
right side of the chart
or the left side of the chart,
these things need to be
independent elements.
They can't be a chart that's
fully functioning anymore.
So I start by using Control
+ X to cut that chart out.
And on the Home Tab on
the Paste dropdown menu,
I'm going to choose Paste Special.
And specifically, I'm pasting
as a type of thing called an
Enhanced Metafile Picture.
The reason that's important is
that Enhanced Metafile
Pictures are pictures
in that they are grouped together shapes,
and that's gonna be
important in a minute here
because then we're going to be able
to isolate the different shapes.
All these other types of
things you don't wanna use.
Windows Metafile actually would work here,
but Enhanced Metafile
works as well or better.
So go ahead and hit OK.
And you can see now that it's
pasted this in as a picture.
And if I go to my Arrange
dropdown menu on the Home tab
and I go to Selection Pane,
you notice it's just listed as Picture 2.
But if I go to the Arrange dropdown menu
and I choose Ungroup,
it'll say, are you sure you wanna do this?
And I click Yes.
And you see it right there?
Now I have Group 4 with
different shapes inside of it.
This is a shape, this is a shape,
this is a shape, and this is a shape.
Now, what I'll do here is I will come in
and click on the outside border
around the outside part of the chart.
And I will rename this
as Executive Border
and click on the inside part of the chart
and rename this as Executive Fill.
And then click on the outside part
of the left side of the chart.
Rename this as Director
Border.
And the inside part of the chart,
and call this Director Fill.
And for the entirety of this group,
I can double-click on the group's name,
and I can name this Simple Chart.
Now, the reason I did this is
because in a little bit here,
I'll want to be able
to select specifically the Executive Fill
as the thing to be clicked
on when I decide to move over
to the complicated version
of the executive results.
Okay, but that's it for right now.
Let's go over and grab the
more complex chart from Excel.
Just Control + C to copy that chart.
Control + V to paste it.
Don't worry that it's not
exactly lined up just yet.
It'll get there in a second.
But I will go to the Design tab,
and let's go with a simpler
version of the color scheme,
something like, let's do
a color breakdown in...
Let's use this soft blue here.
Nah, let's go back to green
so that it looks like it matches.
Okay, so I've got the formatting down,
but I need to be able to
click on different things
and have stuff happen.
So again, this can't be a chart.
It has to be the independent
components of the chart.
So one more time, Control + X to cut.
And then on the Home tab,
use the Paste dropdown
menu, Paste Special,
and paste it specifically
as the picture type Enhanced Metafile.
Click OK, and there it is.
You can see it lines up quite nicely.
But again, in the Selection
pane, it just says Picture 10.
So I go to Arrange and Ungroup.
Notice that it's one gigantic
group of all the shapes.
But you know that what I wanna be able
to do is select the elements
over here on the right
or over here on the left,
so I need to go to
Arrange and Ungroup again
to get all of those to
be independent elements.
And with that,
I can now highlight all the
stuff over here on the right
just by clicking and dragging across it.
And using Control + G,
I can group the right-hand
elements together.
And just rename Group 41
to the Executive Group.
And then highlight all the
stuff on the left here.
Group it using Control + G,
and rename this as the Director Group.
Now, the reason I'm doing this is
because having these grouped together
makes it incredibly easy to do this.
Watch how easy this part is.
I don't wanna see on slide
number four the entirety
of the Director Group, so I
click little eyeball right here,
and they all disappear.
I click for the Executive Group
on the little eyeball right
here, and they all disappear.
So slide number four is the simple version
of the doughnut chart,
but everything is there.
You see that?
And now I can click on slide number four
and Control + D duplicate it
and say this is the slide that needs
to have the executive pieces broken out.
I just click right here
on the little line next
to Executive Group,
and they all show up.
And I click on slide number
four, and I hit Control + D
and I say this is the slide
where the directors should show up.
And I click the little line
where the eyeball's supposed to be.
And you can see right there,
I have slides number four, five, and six,
each one of them where we
have either the simple version
for the entirety of the chart,
a broken down right side of the chart,
or a broken down left side of the chart.
Very nice.
Now, I want to be able to quickly
and easily click on the
right side of the chart
and see the right side broken down,
or click on the left side of the chart
and see the left side broken down.
So I click on the left side of the chart.
If I need to, I can click on
the Executive Fill right here
within that group.
Go to my Insert tab and insert a link.
When I insert a link,
it allows me to go to a
different place in the slide,
and I'll say that's slide number five.
If I'm clicking on the Executive Fill,
I wanna see the executives broken down.
And click OK.
And the exact same thing here on the left.
I can click on my Director Fill.
I can go to Hyperlink.
I can say go to slide
number six and click OK.
And I can go to slide number five,
go to my Director Fill again,
insert a hyperlink, and say yes,
if you were to click on the director part,
go to slide number six, and click OK,
and go to slide number six
and click on the executive
part here on the right.
Add a hyperlink and say when
you click on the right side,
go to slide number five, and hit OK.
Now let's watch that in action.
I'm starting from slide number four.
Using the keyboard shortcut Shift + F + 5,
I can start from slide number four.
So you can see now I can put my mouse
over the right side of the doughnut chart.
Click on it.
You get the different elements here.
And same way, I can click on
the left side of the chart
and see the breakdown of the
different elements as well.
So that's what we're going for there.
So the next stage is to be able
to click on one of the elements over here
on the right side of the doughnut chart
when we're on slide number five
or one of the elements on the left side
of the doughnut chart when
we're on slide number six
to be able to have
something pop out from that.
So I'll go to slide number five here.
Let's say that this little wedge up here,
this is the CEO value, and
I want that to pop out.
Now, as you can see by default,
it's grabbing me the
entire Executive Group.
And if I click down through these,
you'll see each of the
individual different shapes
that are in there.
And what I'm looking for is the CEO shape.
All right, so I'm going to
now cut the CEO shape out
and re-paste it so that it's
not part of the group anymore.
I'm gonna line it up just like so
and then make sure that
it is behind all of this.
So you see the Freeform 12 up here.
Let's actually take a
second, double-click on this,
and call it CEO, right?
And now I'm going to take the CEO wedge,
and I'm going to put it not
inside the Executive Group,
but below the Executive Group.
And you can see what
that does is it puts it
underneath that nice outer
white border right there,
but it is not inside the group,
so it's something that
I can easily get to,
click on, et cetera.
Okay, so next part of the process.
I want to have my little pop-out here.
Well, let's take a second.
Let's look up the CEO
numbers, 1,211, okay.
So now I'll go up here to Insert.
I'll go grab one of these
little pop-out guys.
Maybe this one, okay?
Click and drag to draw the box.
Put it wherever I wanna put it.
Maybe over here.
Maybe I'll make this little
thing show up like that.
Okay, and maybe I'll
change the fill a bit.
Yeah, something like that, okay.
So this is the CEOs,
and there are 1,211 of those people.
And I'll just go ahead
and maybe make this bold
and a little bit bigger.
Okay, and I would like this to show up
by wiping in from left to right.
So on my Animations tab up
here at the top of the screen,
there are lots of different ways
that I could make this show up,
but I like the feel of
it sort of appearing
out of the little wedge.
So for that one, that's Wipe,
but not from the bottom
like you see there,
but rather from the left.
So there it is, it pops out.
And let's actually come
over here to Duration
and shorten the duration
down to 1/4 of a second.
Now, I also want it to disappear
basically the same way.
So I'll go to Add Animation
and add a wipe exit
on top of the wipe entrance.
So I add a wipe exit,
and then I wipe that from
right to left, going back in.
And again, make the
duration about 1/2 a second.
But here's the key to all of that.
By going to the Animation Pane up here
at the top of the screen,
you'll see that now I have
the call-out is coming in,
and it's going out.
I have those two animations right there.
By holding down Shift, I
can select both of them.
You see how both of them are highlighted
in sort of a pink-orange right there?
Now, I don't want this to happen
just when I click forward.
What I wanna is I wanna be
able to go to Trigger here
and say when I click the shape called CEO,
you see that right there?
So I click on CEO,
and that will trigger it to
either show up or disappear.
Let's see whether that works or not.
So I'm going back to
slide number four here.
The first stage is to
say that I'm interested
in the executive side of things.
Click on that, and the
executives get broken out.
Now the next thing is to say
that I'm interested in the CEO.
I can click on the CEO, it pops out.
Click on the CEO, it pops back in.
Back and forth just like that.
Now, obviously you can repeat this
as many times as you need to,
but let's go over to slide number six
and just do this one more time.
Let's say that this little wedge down here
on slide number six,
which I believe, yep, is
Freeform 26 right here.
Let's cut that using Control + X
and paste it using Control + V.
Put it back in its original
location right there.
And put it below that group.
Let's take a second.
Double-click on it.
Oh, what is that shape?
That shape is the first
director, director of IT.
Okay, so this will be
the director of IT shape, great.
I'm going to insert another call-out.
Let's use the same type that
we used the first time around.
Arrange if however we want.
Push this over here maybe.
Pull this over here.
Great, okay.
And again, we'll change the aesthetics
of this thing to that.
And this is the director of IT,
and the number is, I know
it doesn't really matter,
(laughs) 932, 932 people.
And again, we'll make that
cosmetically the same.
We'll bold it.
We'll make it a little bigger, great.
And again, what do we do?
We go to the Animations tab.
We choose a Wipe animation.
This time we'll go the Effect Options
from the right-hand side and
have it take 1/4 of a second.
Go to Add Animation.
Add an exit animation called Wipe.
Have it come from the left-hand side.
And make the duration 1/4 of a second.
Now, again, we click on the two animations
in the Animation Pane that are right here.
Hold down Shift to grab both of them
and say you are specifically triggered
when I click on the thing
called the director of IT.
And that's it.
So now I can go to slide number five.
Pop this open.
I can click on the right
side or the left side,
the right side or the left side,
and get to either of these
two areas being broken down.
Once I'm on the right
side or the left side,
if I want to call out
one of these elements,
I can click on that shape
and pop out the description of that thing.
I can click on the shape
and pop out the description of that thing.
And I can make it expand and contract
as many times as I want to.
If I do this for several of these,
I can pop them out at the
same time if I want to.
There's lots of different
combinations here
that might make sense.
(upbeat music)
