Excel Videos | Office 365 by Freelancer Madhavi - Dailymotion

Freelancer Madhavi

Short E-Learning+Creative Videos on EXCEL.

Transcript

00:00Hello friends, welcome to my channel, I am freelancer Madhvi.

00:18As you can see on the screen, we have state specific sales data and this is a map.

00:24This is a state specific sales data.

00:34You can see tables, state tables, sales amount and country.

00:40If you want, you can add a new map.

00:44If you have a map setting, you will find a map setting.

00:50You can align it through that.

00:52If you don't have a country, you can add other other data.

00:56This is optional for you.

00:58If you have a country specific, you will not have a map selection.

01:02State-wise, you will also have a source.

01:04The source is powered by Bing.

01:08You will take it here.

01:10You have to apply the table to the data.

01:14Then you have to apply the table to the format.

01:18Then you have to apply the conditions.

01:20Then you have to filter the conditions.

01:22Now you have to add a slicer.

01:25What is the slicer?

01:27If you click on the map, you will see the changes in the map.

01:33If you look at the geographical area, like Delhi,

01:37you will click on the map.

01:40Then you will see the filter you will see.

01:44You will also see the sales amount and value.

01:48You will also see the sales amount and value.

01:50You will also see the sales amount and value.

01:53Then you will see the best fit.

01:57You will adjust the text and amount.

01:59Then you will see the table filter.

02:03You will also see the sales amount.

02:06If you look at the area, it is not visible.

02:09Then you will see the sales amount.

02:11Then you will see the sales amount.

02:13Then you will see the area.

02:15The area is big.

02:17You will see the text and amount.

02:20You will see the result near the area .

02:21Thus you will see the cursor itself.

02:24If you show the data from light, as you view the actual tenants,

02:26that it is important to see what you can do.

02:28You will see the changes in the map and then get the filter the area.

02:29And you are going to see the sources.

02:31That according to the map .

02:32Then you will see the map as a Чтобы map from the map.

02:33So this is what you will see.

02:34Theύson-line area will see the島 there.

02:35You will see the inner areas in the map.

02:36Then you will see left on the map.

02:37And you will also see the state-wise data.

02:39So we will get the data on the map.

02:40Then you will need the plot area.

02:41Take the

02:41plot area before it,

02:42If youkommen at the map here you will see the list of

02:43so you can see the fill option, border option and all these things

02:48so you can fill things here

02:52so you can see the text option

02:55so you can see the title option

02:58and color options

03:01so you can see the alignment option

03:04so you can see the chart data

03:07you can see the chart title

03:10so you can see the chart title and arrow sign

03:13so you can see the other options

03:16so you want to keep the chart element

03:19so you can see all the data labels

03:22so you want to see the amount

03:25series name

03:28so you can see the amount

03:31category will see the name of the state

03:34and value will see the value

03:37so you can see the label option

03:39okay

03:40so

03:41and legend

03:43you can also check this

03:45the sales amount

03:48and values

03:51you want to keep left and right

03:54and the chart title is the top

03:57this is the chart title

03:58this is legend

03:59and these are all your values

04:01and data level

04:02okay

04:03so let me see the list

04:04again

04:05I will show you the chart title

04:07here

04:08and data labels

04:09here

04:11and legend

04:12okay

04:13so you have to see the things

04:14in this way

04:15and when you click on the chart

04:16you will change the chart title

04:17So, particularly when things change, if you want to add a slicer, what do you want to do?

04:29You need to insert the slicer option.

04:34You can take the slicer option and take the state, you can take the sales amount.

04:39You can take the column heading according to your column.

04:45Now, the normal thing is that you want to give a preference.

04:49You can also take a small amount of money.

04:51So, you can see the best fit.

04:53Now, if you want to add this filter, you don't want to add the state basis.

04:58So, you want to add the sales amount on the basis.

05:05So, you want to add the sales amount on the basis.

05:10So, you want to add the sales amount.

05:14Now, she looks like this one.

05:25as per choose 98 values, she looks like this one.

05:28So, here there is filter such one basis.

05:32for 4 seconds. Now ignore it and if you say no, I want to see it in Delhi.

05:38If you ignore it, there will be no filter, so it will be straight highlights.

05:42If you don't see the color of text, you will get the color combination,

05:49but you have to click on the text.

05:52The white color is highlighted, so you have to black so that you don't have to read.

05:57So you have to use all these sidebar options.

06:01You have to use the label options.

06:03There will be series, categories, values and numbers.

06:06You have to check all these things.

06:09So you can create this data.

06:12The chart has changed color.

06:14I have blacked background color.

06:16You can add a lot of chart styles.

06:19You can add elements, you can add a quick layout.

06:22You can select data, change chart type, move chart.

06:26You can select all these options.

06:28You can select the ribbon.

06:30You can select the ribbon.

06:32How do you create?

06:34If you like the overall look and requirements,

06:38then you can copy it.

06:40Or you can copy it.

06:42Or you can copy it.

06:44Then you can copy it.

06:46Next page, you can paste .

06:50I will paste all the new series.

06:52Then I will paste all the values.

06:54I will paste the formatting style.

06:56I don't have the formatting style because the formatting style will get the table from the table, okay?

07:00Now I have selected it and I will give it all.

07:04Because I will get something new to the table.

07:06What do we do?

07:08Select the table, including the heading.

07:11Insert table.

07:12Then you can do control team.

07:15Now control A is selected.

07:18I have selected the topic based on which we are creating.

07:26I am not taking the heading and topic.

07:30If you want, you can take it.

07:32You can color it.

07:33You can increase it.

07:34You can change the height and the style.

07:37But I have selected table data.

07:41I have selected table data including heading.

07:43I have selected column heading.

07:45Then what do we do?

07:47We will apply the table.

07:49I have selected columns or lines.

07:53We will apply the table directly.

07:55So you can do control T or insert table.

07:59It depends on how you apply the table.

08:02If you show the shortcut, control T.

08:06Now you will ask the range.

08:08Select you have already done before.

08:10You have selected selection.

08:12So range is okay.

08:14Now I have selected the style.

08:16If you change the style, then you will start.

08:18So you will start.

08:19How do you want it?

08:20Okay?

08:21Multiple styles.

08:22Color combinations are different.

08:24Now I have chosen this.

08:26I have chosen this.

08:27I have chosen this.

08:28I have chosen this.

08:29I have chosen this.

08:30I have chosen this.

08:31Now what do I want to do?

08:32I want to know that I will apply the filter state-wise.

08:35And the chart will tell me about what the values are.

08:41And what the state I have chosen.

08:44The values are given.

08:46So if I choose the filter,

08:48I will make the filter filter.

08:50Now I should change the filter.

08:51Now we don't change the filter.

08:53We can change the amount of sales.

08:55We can change the amount.

08:56We can change the particular state.

08:57you can use this state, so you can use value-wise filters, it's different because the country is one

09:06you want to hide the country, we can only work on the drugs, now I remove the filter, clear filter

09:15now I need a map, so you will get a map in the inside of the insert, you will get a map word

09:22now you can read the details here, use this chart type to compare values and show categories across geographical reasons

09:33use it when you have geographical reasons in your data such as countries, states, counties and postal code

09:46now you can apply to the province, counties and postal codes, so you can apply to the basis of the postal code

09:54now you can see that this is applied, so if there is a problem or a particular range that you can't cover, then you will give a message

10:02you will give a message, so first of all we have to increase the problem, so if there is a problem

10:08we will work on the other state, click on the other state, so if you have a map, I have said settings

10:14you will find a map area in the settings, you will find a map area, here in settings

10:20there is a map area, so you will scroll down and see if you are in general or in which you are in

10:26a map area, you will find a map area, you will find a map area, so you will find a map in Excel

10:44So, you can configure your map and other things like the web options and start-up, you can check what options you need to update.

10:58So, if you don't understand or you can't do it, then you can use a very simple logic that I have given this country.

11:09Now, I am changing, but it doesn't come. So, if I think that my settings are not coming, then I have given it to country.

11:19Now, I have given it to country. Now, what do I want to do? I want to choose specific conditions.

11:27If I don't want to choose this table, I will choose different.

11:30So, what do I want to choose? I want to make a slicer.

11:34Now, I want to choose the slicer. Now, the slicer needs to choose? Sales amount or state.

11:43You can choose both of them. I have taken both of them. Now, I just want to hold, drag and drop.

11:49If you don't like everything on the screen, then the screen can be small or bigger.

11:55So, I have taken the size of the screen.

11:59Now, on which basis I will choose to change.

12:03So, if there are some problems in the map, then we will see what problems in the map.

12:09Because this is the first time we have to work on the map.

12:12So, there are some options here.

12:14Now, there are some important things here.

12:18So, there are some problems in the map.

12:19So, I can also choose to change the map.

12:22If you don't like the internet connection,

12:24if you don't like the map,

12:25then there will be a problem.

12:28Okay?

12:29So, here we have to try.

12:31try to do it because sometimes the internet connection has a problem

12:37so now it will refresh so it will be done

12:40because there is no need to do it

12:45this map is like this, all the patterns and all the patterns are

12:50but here it will not be done so the internet connection has a problem

12:55.

13:00.

13:02.

13:05.

13:06.

13:11.

13:14.

13:15.

13:16.

13:17.

13:18.

13:23.

13:28.

13:30.

13:31.

13:32.

13:35.

13:40.

13:41.

13:42.

13:44.

13:46.

13:49.

13:51.

13:52First of all, we have a filter.

13:54We have a filter.

13:56We cover the whole data.

14:00We cover the whole data.

14:04Now, we have a plot area in the chart.

14:10So, our filter doesn't look like this.

14:12Let's do it.

14:14Let's do it again.

14:16Let's do it again.

14:18Try and remove it.

14:22Then, we have a table area.

14:28It will be done.

14:34Because it doesn't work.

14:36It doesn't work.

14:38It doesn't work.

14:40So, if we have problems, we do not work.

14:50Then, we will check this out.

14:52We will check this out.

14:54Why did we do this work?

14:56I am not doing this.

14:58Okay.

15:00This is what we have done.

15:18See.

15:20So, the problem is that it has no catch data or any problem in the selection and the table cover has no problem.

15:33So, in this way, you will get issues.

15:37You can change the chart style and chart type.

15:40You can choose the color combination.

15:44So, I will take the first or the second one.

15:49So, this is the selection area.

15:52Now, this is the selection area.

15:55I will take this one.

15:58Now, you can do that.

16:02Data label.

16:05I need data label.

16:07But how do you need data label?

16:10Categories and values.

16:13Series name, you will get sales.

16:15So, series name I don't need categories.

16:18And I need values.

16:20Okay?

16:21So, if you want values, you can remove values.

16:23So, you will see the name of state.

16:26And if you want values, you will see values.

16:29Categories.

16:30Okay?

16:31So, you will check what you need.

16:33So, I need the color combination for this.

16:34You will actually have several options.

16:35I will try the other options.

16:36How they will use color combination.

16:37If you need them automatic, you will be automatic.

16:40So, if you need them solid fill, you will need a color.

16:42So, you should choose them when you need color.

16:47In color, how do you need color?

16:49So, if you need a color, you should be able to check them.

16:52In color, you will need to have a color combination.

16:54So if you have readable or not, you need to check which color combination has taken place.

17:03You can have no fill or automatic.

17:07So the color combination will change everything.

17:11Now you have a text option.

17:15The color is black or white.

17:20You can change the color box here.

17:25You can change the chart title.

17:29If you want to change the chart title, then you can drag and drop.

17:35You can change the style.

17:39You can change the color combination here.

17:43Style and color.

17:46You can change the legend.

17:50What did you say?

17:51The legend is left.

17:54If you want to change the chart title, then it was here.

17:58So this is the right.

18:01Top.

18:03Left.

18:05Bottom.

18:07Bottom.

18:08More Legend option.

18:10More legend option.

18:12If you want to change the chart, then I will choose left.

18:16If you want to change the color combination, then you can change the chart.

18:21So this way.

18:23What do you do now?

18:25We have to filter the chart.

18:26Gujarat

18:34okay

18:35this is what is doing

18:37this is working on this way

18:40what do I do? I will remove the filter

18:43is the whole table?

18:45the table is the filter

18:47I have put one value

18:49okay

18:51this is the world specific

18:53which is the chart

18:55this is the chart

18:57you see it

18:59if I put the filter

19:01and put the filter

19:03and put the filter

19:05then you see it

19:07this filter will be like this

19:09okay

19:11what I have done

19:13starting

19:15it is a little different

19:17now what do we do

19:19now

19:21now

19:23one

19:24second

19:25is

19:27remove

19:33side

19:40I want to make

19:41this

19:42I want to make

19:43the formatting style

19:46clear

MAP Chart in Excel | Errors and Solutions

Category

Transcript

Be the first to comment

Excel Videos | Office 365

Recommended