0:00
hi everyone in today's Excel tutorial
0:02
we'll create a dynamic chart using the
0:04
switch or ifs function this quick method
0:06
makes a chart adaptable to changing data
0:08
sets let's dive in the sheet contains
0:11
three data sets first we create a drop-
0:14
down list to switch between these data
0:16
sets dynamically select cell E1 and use
0:19
data validation to create a drop- down
0:21
list with the source range B1 to D1
0:23
containing sales profit and expenses now
0:26
when you click the drop- down arrow any1
0:28
you'll see the options Sal
0:30
profit and expenses selecting one of
0:33
these will control the data displayed in
0:34
the chart next we'll use the switch
0:37
function to dynamically display the data
0:39
based on the drop- down selection in
0:41
cell F1 enter the formula as shown on
0:43
screen this formula checks the value any
0:46
E1 if it's sales it Returns the entire
0:49
range B1 to B13 if it's profit it
0:52
returns C1 to C13 and if it's expenses
0:58
D13 notice how the data in column F
1:01
updates dynamically when you change the
1:03
drop- down selection in E1 this is
1:05
because the switch function evaluates
1:07
the value in E1 and Spills the
1:10
corresponding range into column F let's
1:12
create the chart now first select the
1:14
months in column A then hold down the
1:16
control key and select the dynamic data
1:19
in range F1 to f13 this will select a
1:22
non-contiguous range in Excel next go to
1:25
the insert Tab and choose the chart type
1:27
you want such as a line chart or column
1:29
chart Excel c will insert the chart onto
1:31
your sheet now test the chart by
1:33
selecting different options from the
1:35
drop down and cell E1 as you can see the
1:38
data in the chart updates instantly when
1:40
you switch between sales profit and
1:43
expenses this Dynamic behavior is
1:45
powered by the combination of the drop-
1:47
down list and the switch
1:54
function you can achieve the same result
1:57
using the ifs function here's how in
1:59
cell F1 replace the switch formula with
2:02
the ifs formula as shown on screen this
2:04
formula Works similarly to switch
2:06
evaluating each condition in sequence
2:09
when you press enter the data spills
2:11
into the range F1 to f13 just like
2:14
before and that's how you can quickly
2:16
create Dynamic charts in Excel using the
2:18
switch or if function this method is
2:20
simple efficient and makes your charts
2:22
interactive and engaging if you found
2:25
this tutorial helpful please give it a
2:26
thumbs up subscribe to my channel and
2:29
hit the notification for more Excel tips
2:30
and tricks thanks for watching and see
2:33
you in the next video
