1
00:00:00,820 --> 00:00:07,960
Before we started to do real on Excel charts it is important to understand what our charts and why we

2
00:00:07,960 --> 00:00:15,850
invest our time and other resources on creating them what additional value we are generating by converting

3
00:00:15,850 --> 00:00:26,270
our data in the form of charts so let's start with the basics chart is a visual representation of numerical

4
00:00:26,280 --> 00:00:28,260
data.

5
00:00:28,260 --> 00:00:35,430
It can make your numbers more understandable charts represent our data in the form of pictures which

6
00:00:35,520 --> 00:00:43,250
often helps us to support trends and patterns that otherwise go unnoticed.

7
00:00:43,260 --> 00:00:47,180
Let's look at an example to understand this.

8
00:00:47,310 --> 00:00:54,980
Here we have monthly sales data of a company and let us see and try to identify the pattern in this

9
00:00:54,980 --> 00:00:58,360
data so you can look at this numerical data.

10
00:00:58,520 --> 00:01:09,090
I'll give you 10 seconds to analyze this and identify the pattern.

11
00:01:09,140 --> 00:01:16,470
I hope you have identified deeper than no let's look at the chart of sales of another company and try

12
00:01:16,470 --> 00:01:17,200
to identify.

13
00:01:17,240 --> 00:01:20,370
But then again you have trends against

14
00:01:24,230 --> 00:01:29,570
I hope you have noticed the difference between the two scenarios and I am sure that you would not need

15
00:01:29,570 --> 00:01:35,960
10 seconds to identify the pattern in the second chart in case of Company B.

16
00:01:36,010 --> 00:01:42,700
You can easily interpret that the sales are higher in the middle months of the year whereas you need

17
00:01:42,700 --> 00:01:50,470
much more time in interpreting the same result for Company A If we had millions of values instead of

18
00:01:50,470 --> 00:01:57,250
just drill it would be almost impossible for us to interpret these hidden patterns by just looking at

19
00:01:57,250 --> 00:02:05,440
these numerical values charts become more and more important as these days of data increases so with

20
00:02:05,440 --> 00:02:10,990
this backdrop in the next video we will be learning how to convey a message using a chart.