1
00:00:00,750 --> 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,920 --> 00:00:15,180
but creating a chart that will convey the message is difficult.

3
00:00:16,980 --> 00:00:19,570
So in this lecture, we will learn about the easy part.

4
00:00:19,980 --> 00:00:22,080
That is how to create a basic chart.

5
00:00:23,940 --> 00:00:29,220
And the later part of the course we will learn how to create these amazing charts which convey the message

6
00:00:30,650 --> 00:00:32,060
to to create a chart.

7
00:00:32,370 --> 00:00:33,800
Just select your data.

8
00:00:37,600 --> 00:00:41,980
And click on the recommended darts option in the insert menu.

9
00:00:45,360 --> 00:00:50,700
Here you can see the four options that Israel is giving you, you can select any suitable target.

10
00:00:51,180 --> 00:00:55,050
Here we are selecting the bar type chart for the data.

11
00:00:56,130 --> 00:01:01,450
So you can see that a bar chart representing our data is now plotted.

12
00:01:02,850 --> 00:01:07,780
You can see that Excel has automatically identified what goes where.

13
00:01:08,040 --> 00:01:17,250
So it has automatically pulled sales as the chart title these Genset March, April, these were months

14
00:01:17,670 --> 00:01:25,440
have been given as the horizontal axis labels and vertical axis labels have been have been decided by

15
00:01:25,440 --> 00:01:26,400
the executive.

16
00:01:28,570 --> 00:01:38,080
Excel also provides some default design options and layout options if we go to the design that we can

17
00:01:38,080 --> 00:01:39,880
change the structure of our chart.

18
00:01:41,560 --> 00:01:44,300
There are a few different layout options available.

19
00:01:45,010 --> 00:01:51,670
You can hover over each of these to get a preview of what will happen in your chart area.

20
00:01:54,780 --> 00:02:02,550
There are also color options available and some team options available, you can change the color of

21
00:02:02,550 --> 00:02:04,800
the chart using these options.

22
00:02:11,350 --> 00:02:20,380
And from these states, we can change the style of our chart, so if I hover over this black one, you

23
00:02:20,380 --> 00:02:22,340
can see that it has a black background.

24
00:02:22,900 --> 00:02:27,070
The bars are having green outline and they are transparent.

25
00:02:29,310 --> 00:02:35,940
This next one has no great lines and so on, you can see the different styles that is providing to you.

26
00:02:36,980 --> 00:02:40,550
This is how we create a chart using a single click.

27
00:02:41,850 --> 00:02:46,240
But in our schools, we will hardly use these default styles.

28
00:02:47,310 --> 00:02:54,320
We will learn how to create charts from scratch so that we have all the customized options at our disposal.

29
00:02:55,710 --> 00:03:01,650
The amount of time that you will invest in choosing the right format, right color and then the right

30
00:03:01,650 --> 00:03:06,670
style from all these options will be equal to creating a new start from scratch.

31
00:03:08,850 --> 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

32
00:03:15,690 --> 00:03:17,280
types from scratch.