1
00:00:04,460 --> 00:00:07,770
Charts visually display quantitative data.

2
00:00:07,770 --> 00:00:14,160
They give us a quick impression of the size of the data and whether there are any patterns associated

3
00:00:14,160 --> 00:00:15,230
with data.

4
00:00:15,240 --> 00:00:21,240
You can also compare two data sets much faster if you use a column chart than if you have to go through

5
00:00:21,240 --> 00:00:29,010
the numbers and compare. The most common chart types used in company reports are column or stacked column,

6
00:00:29,400 --> 00:00:32,040
line, bar, and pie chart.

7
00:00:32,049 --> 00:00:35,040
Now this is just a list of the most common ones.

8
00:00:35,100 --> 00:00:38,910
If you take a look at the chart types you have available in Excel.

9
00:00:38,910 --> 00:00:41,650
There are a lot more options.

10
00:00:41,670 --> 00:00:49,320
Each chart type serves a purpose. Column charts for example are great for comparison or for ranking of

11
00:00:49,320 --> 00:00:51,370
categories in order.

12
00:00:51,370 --> 00:00:58,200
They're also easy to understand by different audiences because we're all used seeing column charts in

13
00:00:58,200 --> 00:00:59,490
the media.

14
00:00:59,490 --> 00:01:08,070
The bar chart is similar and it's more suited if you have long category labels or a lot of bars. So it

15
00:01:08,070 --> 00:01:12,560
looks neater to organize a data in a bar chart than a column chart.

16
00:01:12,680 --> 00:01:19,610
The line chart is well suited for showing trends. For example, how sales values change over time.

17
00:01:19,860 --> 00:01:23,260
The pie chart is also common in company reports.

18
00:01:23,340 --> 00:01:27,480
It's used for visualizing parts to whole relationships.

19
00:01:27,750 --> 00:01:32,160
For example, the sales numbers broken down by division.

20
00:01:32,160 --> 00:01:36,610
But it's not well liked by data visualization experts.

21
00:01:36,630 --> 00:01:42,870
The reason is if you have a lot of pieces of the pie, it's difficult to compare the size of the pieces

22
00:01:42,930 --> 00:01:44,740
with one another.

23
00:01:44,770 --> 00:01:52,260
Now in addition to these chart types which are optimal for most audiences, we have more specialized charts.

24
00:01:52,320 --> 00:01:58,560
For example the Pareto chart which brings attention to the categories that have the most impact.

25
00:01:58,620 --> 00:02:03,320
There's also the histogram which shows the distribution of the data.

26
00:02:03,510 --> 00:02:10,240
We have the tree map and Sunburst charts which are suited for displaying hierarchical data.

27
00:02:10,259 --> 00:02:13,130
We're going to be covering all these in this section.

28
00:02:13,140 --> 00:02:19,020
The great thing about Excel charts in general is that they're flexible. You can combine different

29
00:02:19,020 --> 00:02:26,760
series types in one chart to create your own customized combination chart or combo chart, which is another

30
00:02:26,760 --> 00:02:28,740
topic that we're going to cover in this section.

31
00:02:28,890 --> 00:02:34,850
There's so much more to charts and data visualization than we get to cover in this course.

32
00:02:34,890 --> 00:02:38,010
I get you started here so you can start exploring.