0:00
hi in this video we'll create a table
0:02
and insert a chart that automatically
0:04
updates as the data grows or changes to
0:07
start we've inserted a table on a blank
0:09
sheet using the insert tab you can also
0:11
quickly create a table by selecting cell
0:13
range and pressing contrl T but if you
0:16
already have data in a worksheet and
0:17
want to convert it into a table you can
0:19
use the format as Table menu available
0:21
on the Home tab if you're new to excel
0:23
tables check out our previous video the
0:26
link is in the description sometimes
0:28
when working with charts in Excel you
0:30
want them to expand or Shrink
0:31
dynamically as new data is added
0:34
modified or removed the easiest way to
0:36
achieve this is by using an Excel table
0:38
as the charts data source since tables
0:41
automatically adjust their size when
0:43
data changes any chart linked to a table
0:45
will update automatically now as we
0:48
enter new data notice how the table
0:50
expands automatically and the new
0:52
entries adopt the same formatting next
0:55
let's create a chart with the table or a
0:57
table cell selected go to the insert tab
1:00
choose recommended charts from the
1:02
charts group and select a suitable chart
1:04
type here we've inserted a clustered
1:06
column chart adjust the size and
1:08
position of the chart as
1:12
needed now let's test how the chart
1:15
updates as we enter more data into the
1:17
table the chart dynamically expands to
1:19
reflect the changes without any manual
1:22
adjustments this is one of the easiest
1:24
ways to create a chart that updates
1:26
automatically when the source data
1:40
it doesn't end there when you use table
1:42
features like sorting and filtering the
1:44
chart updates accordingly for example we
1:47
applied a filter on the bonus column to
1:49
display only values greater than 3,000
1:52
after applying the filter the table now
1:54
shows only the records where the bonus
1:56
exceeds 3,000 and the chart updates
1:59
instant to reflect these changes
2:01
similarly if we apply a filter to show
2:04
bonuses less than 1,000 the table
2:06
adjusts to display only those records
2:08
and once again the chart updates
2:20
automatically if you want to chart the
2:21
top 10 records you can use the top 10
2:24
filter from the autof filter options
2:26
this will update both the table and the
2:27
chart automatically displaying only the
2:37
values to display the top five records
2:39
use the same top 10 filter just change
2:42
the value from 10 to 5 the table and
2:44
chart will update instantly to show only
2:49
entries similarly you can filter any
2:52
data such as the department column to
2:54
display data for specific departments
2:56
you can also filter the position column
2:58
to update both the table table and chart
3:00
accordingly by using tables as a charts
3:02
data source you can easily analyze
3:05
different data groups without manually
3:06
entering new data or creating separate
3:09
charts filters and other table features
3:11
make your charts interactive and dynamic
3:14
allowing you to focus on specific
3:15
insights effortlessly I hope you found
3:17
this video useful if you did please like
3:19
this video share it with your friends
3:22
and subscribe to my channel for more
3:23
Excel tips thank you for watching and
3:25
see you in the next video
