1
00:00:00,768 --> 00:00:01,536
In this lecture

2
00:00:02,304 --> 00:00:05,888
We will learn how to create charts with just one click.

3
00:00:07,168 --> 00:00:09,728
you see creating charts is very easy

4
00:00:10,752 --> 00:00:14,080
But creating a chart that will convey the message

5
00:00:14,336 --> 00:00:15,872
Is difficult.

6
00:00:16,896 --> 00:00:19,712
in this lecture we will learn about the easy part

7
00:00:19,968 --> 00:00:22,016
That is how to create a basic chart.

8
00:00:23,808 --> 00:00:29,184
in the later part of the course we will learn how to create the amazing charts which convey the message.

9
00:00:30,720 --> 00:00:32,000
so to create a chart

10
00:00:32,256 --> 00:00:34,304
Just select your data

11
00:00:37,376 --> 00:00:42,496
And click on the recommended charts option in the insert menu.

12
00:00:45,056 --> 00:00:50,688
Here you can see the four options that Excel is giving you, you can select any suitable chart

13
00:00:50,944 --> 00:00:55,296
We are selecting the bar type chart for our data.

14
00:00:56,064 --> 00:00:58,368
So you can see that a bar chart

15
00:00:58,624 --> 00:01:00,672
Representing our data is now

16
00:01:00,928 --> 00:01:01,696
plotted.

17
00:01:02,720 --> 00:01:06,048
You can see that Excel has automatically identified

18
00:01:06,560 --> 00:01:07,840
What goes where

19
00:01:08,096 --> 00:01:09,888
so it has automatically

20
00:01:10,144 --> 00:01:16,288
Put sales as the chart title these Jan Feb March April

21
00:01:16,544 --> 00:01:17,312
these were the months

22
00:01:17,568 --> 00:01:20,384
Have been given as the horizontal Axis labels

23
00:01:21,408 --> 00:01:26,528
And vertical Axis labels have been decided by the Excel itself.

24
00:01:28,576 --> 00:01:33,184
Excel also provides some default design options and layout options.

25
00:01:33,952 --> 00:01:36,256
If we go to the design tab

26
00:01:37,280 --> 00:01:39,840
We can change the structure of our chart

27
00:01:41,376 --> 00:01:44,448
there are few default layout options available

28
00:01:44,960 --> 00:01:47,008
You can hover over each of these

29
00:01:48,288 --> 00:01:49,568
To get a preview of

30
00:01:49,824 --> 00:01:51,616
What will happen in your chat area.

31
00:01:53,920 --> 00:01:56,992
there are also colour options available

32
00:01:57,248 --> 00:01:59,552
and some theme options available.

33
00:02:00,576 --> 00:02:02,112
You can change the color

34
00:02:02,368 --> 00:02:03,136
of the chart

35
00:02:03,648 --> 00:02:04,928
Using these options.

36
00:02:11,328 --> 00:02:15,680
From these styles we can change the style of our chart.

37
00:02:16,704 --> 00:02:19,264
If I hover over this black one

38
00:02:20,032 --> 00:02:25,664
You can see that it has a black background the Bars are having green outline

39
00:02:25,920 --> 00:02:27,456
and they are transparent.

40
00:02:27,712 --> 00:02:33,856
This next one has no grid lines and so on you can see the different styles

41
00:02:34,112 --> 00:02:38,720
That excel is providing to you.This is how we create a chart

42
00:02:38,976 --> 00:02:40,768
Using single click.

43
00:02:41,024 --> 00:02:43,072
But in our course

44
00:02:43,584 --> 00:02:46,400
We will hardly use these default styles

45
00:02:46,656 --> 00:02:52,800
We will learn how to create our charts from scratch so that we have all the customized

46
00:02:53,056 --> 00:02:59,200
Options at our disposal the amount of time that you will invest in choosing the right format

47
00:02:59,456 --> 00:03:02,272
right color and then the right style

48
00:03:02,528 --> 00:03:06,624
From all these options will be equivalent to creating a new chart from scratch.

49
00:03:06,880 --> 00:03:13,024
so in the coming videos we will be focusing on each chart Type one

50
00:03:13,280 --> 00:03:16,096
by one and will be creating each of these chart types

51
00:03:16,120 --> 00:03:18,120
from scratch.