0:00
hi everyone and welcome back to Excel
0:03
Wiz In today's video I'm going to show
0:05
you how to rotate charts in Excel using
0:08
three different uh charts The first one
0:11
is a 3D chart a two bar chart and a pie
0:14
chart So let's get started
0:17
So let's start by let's start by a pie
0:21
chart So using the the data that we have
0:24
here for import and export just
0:29
select all and click on insert Under
0:33
insert let's choose one pie chart Let's
0:36
choose the 2D pie chart
0:41
So once you have this the next thing
0:43
that you uh you do just uh right click
0:52
and then click on format data series
0:59
Then on angle or first slice you can
1:02
adjust this Uh please watch the colors
1:05
on the on the pie and see as you adjust
1:08
the numbers the color positions changes
1:12
So you can adjust this to any position
1:15
that you want So this is how you can
1:17
actually rotate a a pie chart in in
1:20
Excel So whether you want to use it on
1:24
your PowerPoint presentation or just any
1:27
other place you can use this to to
1:30
rotate it Moving Let's move to a 2D bar
1:36
The process is the same Select your data
1:40
click on insert and now choose a 2D bar
1:43
chart Let's use the first one
1:50
what you you're going to do you're now
1:52
going to right click the axis
1:56
down here where you have your numbers
2:03
you right click on it
2:09
for your 2D bar chart So once you get
2:12
your chart click on your x-axis
2:25
Click on your x-axis Sorry right click
2:27
on your x-axis Ensure that
2:42
Uh once you right click it click on
2:47
and on your on your right you're going
2:50
to find uh under axis position
2:53
categories in reverse order Click on it
2:56
check checklist it And once you do as
3:00
you can see your chart is going to be
3:03
flipped vertically or horizontally You
3:06
can play around with it by unchecking it
3:09
and checking it And as you can see um
3:12
there's a different there's a different
3:15
uh flip that's happening So that's how
3:17
you can rotate a 2D bar chart So let's
3:21
move on to a 3D chart
3:29
and then now let's choose a 3D 3D column
3:37
3D column You can choose to change the
3:39
title of your chart if you choose But we
3:43
are not going to do that So what you're
3:45
going to do just right click on the
3:51
and then you uh down here you find a 3D
3:56
Once you get the 3D rotation you can now
3:59
choose to adjust your X and Y rotations
4:02
as you please So just watch as I
4:05
increase the X rotation
4:09
The higher I go you can see the it's
4:12
getting rotated And if I do with the X
4:16
with a Y you can see the difference So
4:19
that's how you get to rotate your chart
4:23
in Excel Either you're using a 3D chart
4:27
a two bar chart or a pie chart So if you
4:30
got any questions about how to rotate
4:33
charts in Excel please feel free to
4:35
leave a comment in the comment down
4:37
section And if you need any different
4:40
kind of video for Excel please let us
4:42
know on the comment down section and
4:44
we'll do it for you And again as always
4:47
thank you very much for watching and see
4:49
you again in the next video Goodbye