1
00:00:00,390 --> 00:00:01,230
No, next.

2
00:00:02,470 --> 00:00:08,710
We want to create this revenue chart where we are using columns to represent the revenue value.

3
00:00:10,310 --> 00:00:18,530
So this is our data, we have the data of past five years and then we have a projected data of year

4
00:00:18,530 --> 00:00:19,580
2021.

5
00:00:22,300 --> 00:00:28,660
So again, to the chart, we will go to insert and this time we want to call them chart, so we will

6
00:00:28,660 --> 00:00:31,720
click on here and click on to the column.

7
00:00:34,970 --> 00:00:44,660
Now, another simple way to talk is just to select the data you want to contact and then go to chart

8
00:00:45,080 --> 00:00:49,520
and click on the desired chart if you do that.

9
00:00:50,480 --> 00:00:57,800
Excel will try to find out what you are trying to plot on your chart, and it may come at some error

10
00:00:57,810 --> 00:00:58,330
sometimes.

11
00:00:58,330 --> 00:01:03,040
So, for example, here we want your values as horizontal axis.

12
00:01:03,860 --> 00:01:09,560
So instead of that Excel as selected, one, two, three, four as the horizontal axis.

13
00:01:10,250 --> 00:01:20,270
And then Excel has added 2016 2017 era values as a primary axis, as a primary axis or vertical axis.

14
00:01:22,530 --> 00:01:29,140
So even if you insert a chart by this matter, you can edit the data later on.

15
00:01:29,160 --> 00:01:32,310
So, for example, go to select data.

16
00:01:34,950 --> 00:01:42,450
Now, here also you can see that in cities, we have two cities here, revenue, but we want it as a

17
00:01:42,450 --> 00:01:45,090
horizontal axis label, not as a cities.

18
00:01:45,420 --> 00:01:46,140
So you can.

19
00:01:48,720 --> 00:01:57,090
You can remove it from here and then in the horizontal axis instead of this one, two, three, four,

20
00:01:57,090 --> 00:01:59,490
we want years, so.

21
00:02:00,640 --> 00:02:01,930
Select the year with you.

22
00:02:07,840 --> 00:02:10,660
So now our chart is looking good.

23
00:02:11,530 --> 00:02:18,640
We have the revenue figure in the form of columns and we have years in the form of horizontal axis.

24
00:02:19,150 --> 00:02:22,540
We also have a legend and we also have a chart titled.

25
00:02:26,390 --> 00:02:28,730
Now, since this is the projected value.

26
00:02:29,850 --> 00:02:38,100
Year 2021 is a projected value, so we can calarco this column so that other people can easily identify

27
00:02:38,190 --> 00:02:40,090
that this is not a real value.

28
00:02:40,110 --> 00:02:41,510
This is the projected value.

29
00:02:42,180 --> 00:02:45,330
So all the other columns are in orange color.

30
00:02:46,340 --> 00:02:52,390
To mention that you're 20, 21 is a projected value, we will change the color of this column.

31
00:02:53,450 --> 00:02:54,590
So to change the color.

32
00:02:56,490 --> 00:03:02,980
Click on this bar, you will see that all the bars are selected now to select this individual bar,

33
00:03:03,000 --> 00:03:05,430
you have to click on this column.

34
00:03:05,920 --> 00:03:10,500
So once you double click it, you will see that on this column is selected.

35
00:03:11,160 --> 00:03:18,670
Now, go to this Phil and line option and select the color that you want right now.

36
00:03:18,720 --> 00:03:20,640
I will use a gray color.

37
00:03:22,380 --> 00:03:25,380
To highlight that this is the projected value.

38
00:03:26,350 --> 00:03:32,890
Now, you can see that our chart is looking like the chart that we have in the dashboard.