WEBVTT

00:00.160 --> 00:01.839
When working with Excel charts, you

00:01.839 --> 00:03.200
might encounter situations where you

00:03.200 --> 00:04.960
want to add or remove specific data

00:04.960 --> 00:06.560
points without having to delete the

00:06.560 --> 00:08.440
entire chart or recreate it from

00:08.440 --> 00:10.800
scratch. Excel provides an efficient way

00:10.800 --> 00:12.480
to manage the data displayed in your

00:12.480 --> 00:14.960
charts. To remove or add data to an

00:14.960 --> 00:16.720
existing chart, the first step is to

00:16.720 --> 00:18.560
select the chart you are working on.

00:18.560 --> 00:20.240
After selecting the chart, you need to

00:20.240 --> 00:22.400
go to the data selection settings. This

00:22.400 --> 00:24.480
allows you to choose exactly which data

00:24.480 --> 00:26.480
you want to include or exclude from the

00:26.480 --> 00:28.560
chart. For example, if you only want to

00:28.560 --> 00:30.800
show data for product A, you can remove

00:30.800 --> 00:32.880
product B and product C from the charts

00:32.880 --> 00:34.800
data source. Simply select the

00:34.800 --> 00:36.559
corresponding data series for product B

00:36.559 --> 00:38.320
and product C, then remove them. Once

00:38.320 --> 00:39.840
you confirm the changes by clicking

00:39.840 --> 00:42.000
okay, the chart will update and only

00:42.000 --> 00:44.000
display the data for product A. You can

00:44.000 --> 00:46.200
also filter the data by months or other

00:46.200 --> 00:48.719
categories. By selecting specific months

00:48.719 --> 00:50.480
in the data selection dialogue, such as

00:50.480 --> 00:52.879
January, April, and May, you can control

00:52.879 --> 00:54.399
which time periods are shown in the

00:54.399 --> 00:56.480
chart. This gives you flexibility to

00:56.480 --> 00:59.320
focus on the most relevant data for your

00:59.320 --> 01:01.760
analysis. If you want to add new data to

01:01.760 --> 01:03.680
the chart, go back to the data selection

01:03.680 --> 01:05.920
settings and click the plus sign to add

01:05.920 --> 01:08.000
a new series. Enter the name of the new

01:08.000 --> 01:10.240
data series and adjust the data range as

01:10.240 --> 01:12.479
needed. This way, you can expand the

01:12.479 --> 01:14.720
chart by adding new data points without

01:14.720 --> 01:17.040
needing to recreate the entire chart.

01:17.040 --> 01:19.040
Finally, review how the data is

01:19.040 --> 01:20.720
displayed in the chart, ensuring it

01:20.720 --> 01:22.960
reflects your intended presentation.

01:22.960 --> 01:24.640
These simple steps allow you to manage

01:24.640 --> 01:26.640
your Excel chart efficiently by adding

01:26.640 --> 01:28.479
or removing data directly within the

01:28.479 --> 01:30.479
chart structure without affecting the

01:30.479 --> 01:33.840
original data set.