00:00i am constantly amazed by excel and what it can do like for example to use 3d excel power map
00:07like this where you can incorporate your data to the map pan zoom in and out of a country and
00:13even
00:13show chart as a heat map let's learn to add the power map to your data set first you're going
00:19to
00:19place your cursor right at the center of your data set and press ctrl a and this is going to
00:25highlight
00:25all your data set now from the ribbon you're going to select insert and then under the tour
00:31there's a 3d map click on it to pen just left click on the mouse and move left and right
00:37up and down
00:38roll your wheel mouse to zoom in and out like this let's integrate sales data to this 3d map by
00:45adding
00:45it to the height section like this and make sure there's no aggregation we can also distinguish each
00:52data of each region by selecting region under this category and after that you can see every bar
00:57chart has its own color and finally we can modify the chart type to heat map which can be useful
01:03to
01:03identify good and bad actors in my next video i'll show you how you can download this 3d map
01:09for presentation stay tuned
