Excel MAP Chart:
To create an "Excel MAP," you can use the built-in map Charts or the 3D Maps feature by going to the Insert tab, selecting Charts, and then choosing Maps.
This feature helps visualize geographical data by creating maps with color-coded regions based on your data.
-----------------------------------------------
#excel #map #chart #states #sales #data #marketing #analysis #dynamics365 #msexcel #exceltips #exceltricks
To create an "Excel MAP," you can use the built-in map Charts or the 3D Maps feature by going to the Insert tab, selecting Charts, and then choosing Maps.
This feature helps visualize geographical data by creating maps with color-coded regions based on your data.
-----------------------------------------------
#excel #map #chart #states #sales #data #marketing #analysis #dynamics365 #msexcel #exceltips #exceltricks
Category
📚
LearningTranscript
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
Recommended
2:03
|
Up next
1:09
0:57
1:25
0:33
1:33
0:57
1:32
Be the first to comment