0:00
In Excel, it is possible to filter the
0:01
data that is displayed on a chart
0:03
without having to create a new data set
0:04
or modify the original data source. This
0:07
technique is especially useful when you
0:09
want to focus on specific aspects of
0:10
your data or present a clearer visual
0:12
analysis. To filter data on a chart in
0:15
Excel 365, you start by selecting the
0:17
chart you want to modify. Once the chart
0:19
is selected, go to the chart design tab.
0:21
From there, click on the select data
0:23
option. This action opens the select
0:25
data source window which allows you to
0:27
define exactly which data series you
0:28
want the chart to display. In this
0:30
window, you can see a list of the
0:32
available data series in your chart. To
0:34
filter a specific product or category,
0:36
you can select the desired series and
0:38
modify the data range. For example, you
0:40
might choose to show only data for
0:41
product A and select the corresponding
0:43
range, such as months from January to
0:45
June. After clicking okay, the chart
0:48
will update and show only the filtered
0:49
data for product A. You can also select
0:52
multiple products or categories if you
0:53
want to compare them, such as filtering
0:55
the chart to display data for both
0:57
product A and product B within specific
0:59
months like January and February. The
1:01
chart will update automatically
1:03
reflecting the filters you have applied
1:05
without changing or affecting the
1:07
original data in the spreadsheet. This
1:09
method allows you to focus your analysis
1:11
and presentation on particular areas of
1:13
your data without altering the
1:14
underlying structure of your Excel file.
1:16
It is an efficient and effective way to
1:18
manage the visual representation of your
1:20
data in Excel. And it helps keep your
1:22
original data sets intact while still
1:24
allowing flexible filtering on your