1
00:00:00,840 --> 00:00:09,660
In this lecture we learn how to create charts with just one click using creating charts is very easy

2
00:00:10,980 --> 00:00:17,010
but creating a chart that will convey the message is difficult.

3
00:00:17,020 --> 00:00:19,890
So in this lecture we will learn about the easy part.

4
00:00:20,070 --> 00:00:23,740
That is how to create a basic chart.

5
00:00:24,080 --> 00:00:29,220
In the later part of the course we will learn how to create these amazing charts which can really message

6
00:00:30,930 --> 00:00:32,330
to create a chart.

7
00:00:32,400 --> 00:00:33,740
Just select your data

8
00:00:37,730 --> 00:00:44,770
and click on the recommended charts option in the Insert menu.

9
00:00:45,440 --> 00:00:48,900
Here you can see the four options that Excel is giving you.

10
00:00:49,070 --> 00:00:51,230
You can select any suitable chart.

11
00:00:51,230 --> 00:00:59,390
Here we are selecting the bar type chart for our data so you can see that a bar chart representing our

12
00:00:59,390 --> 00:01:07,790
data is now plotted and you can see that Excel has automatically identified what goes with it.

13
00:01:08,080 --> 00:01:13,580
So it has automatically put sealed as the chart title.

14
00:01:13,590 --> 00:01:22,670
These Jan for March April these will be months have been given as the horizontal axis labels and vertical

15
00:01:22,670 --> 00:01:31,110
axis labels have been picked have been decided by the executive Excel also provide some day forward

16
00:01:31,140 --> 00:01:33,890
design options and layout options.

17
00:01:34,020 --> 00:01:43,920
If we go to the design that we can change the structure of our chart there are few before layout options

18
00:01:43,920 --> 00:01:44,890
available.

19
00:01:45,090 --> 00:01:54,140
You can put all each of these to get a preview of what will happen in your chart area.

20
00:01:54,840 --> 00:02:00,510
There are also color options available and some theme options available.

21
00:02:00,750 --> 00:02:04,800
You can change the color of the chart using these options

22
00:02:11,400 --> 00:02:16,530
and from these styles you can change the style of our chart.

23
00:02:16,750 --> 00:02:22,770
So if a whole over this black one you can see that it has a black background.

24
00:02:22,920 --> 00:02:29,330
The buzzer having green outline and they are transparent.

25
00:02:29,370 --> 00:02:32,400
This next one has no grid length and so on.

26
00:02:32,400 --> 00:02:36,950
You can see the different states that Excel is providing to you.

27
00:02:36,960 --> 00:02:41,350
This is how we create a chart using a single click.

28
00:02:41,910 --> 00:02:47,280
But in our goals we will hardly use these default styles.

29
00:02:47,370 --> 00:02:53,790
We will learn how to create our charts from scratch so that we have all the customized options at our

30
00:02:53,790 --> 00:02:55,740
disposal.

31
00:02:55,740 --> 00:03:01,670
The amount of pain that you will invest in choosing the right format right color and then the right

32
00:03:01,680 --> 00:03:08,610
style from all these options will be equal into creating a new job from scratch.

33
00:03:08,910 --> 00:03:15,450
So in the coming videos we will be focusing on each type one by one and will be creating each of these

34
00:03:15,450 --> 00:03:17,390
chart types from scratch.