VehiclesFashionRecipesBlogsHuntTravelsSportFunHandmadeITEducation
Mini-Games
x

x
zakruti.com » IT - Software » IT, programs, coding
How to Turn Data into Interactive Excel Map Chart - Kevin Stratvert

How to Turn Data into Interactive Excel Map Chart - Kevin Stratvert

FBTwitterReddit

video description

Rating: 4.0; Vote: 1
How to Turn Data into Interactive Excel Map Chart - Kevin Stratvert learn how to take data and transform it into a visual map using Microsoft Excel. First, we look at how to create an Excel map using two columns of data. Next, we explore how to create a dynamic map that you can interact with using a drop-down list. With a dynamic map, the maps view changes based on the user's selection. Last, we look at how to build 3D maps in Excel using Power Map, which allows you to explore your data using multiple fields, times, and filters. - Additional resources - Sample spreadsheet I used to follow-along: https://1drv.ms/x/s!AmxrofZZlZ-whMtzQ49KJE9lQcbhag?e=87s4ZC - How to Build Excel Interactive Dashboard: https://youtu.be/MTlQvyNQ3PM - Get started with Power Map in Excel: https://support.microsoft.com/en-us/office/get-started-with-power-map-88a28df6-8258-40aa-b5cc-577873fb0f4a
Date: 2022-03-15

Comments and reviews: 7


How can I create a -pie of pie- interactive pivot chart? I don't want to group some items into a single pie slide -other- and explode it in a second little pie. I don't need that, NO! I want to create a pie made of (i.e.) 5, 6 slices. Then, I want to select one of these slices and all the -below items- explode in detail in a second full size cake. Is it possibile? In this way I have an interactive pie view of -together and below- items. I hope I was clear ;-p
reply

-Kevin Stratvert, Firstly your tutorials are really precise and great! I am from South Africa, and would like to create a map for lets say only one City in South Africa , with all of its Suburbs , however I cannot seem to get the map working, could it be that the mapping is not set up for South African suburbs or am I expecting too much?
reply

When I try to export a time lapse as a video, it get to 99% then stops. No error messages, it just say -Creating your video. this could take a few minutes...- . Anyone know what's happening or how to fix it? Is it just too much data?
reply

For the list of regions( at 5:03), I would have used -unique- and -sort- to make it dynamic. Not so much new regions will be created thought- Very clever way to use filter, thanks for this interesting video Kevin!
reply

i'm using online ms 365 but there is no map option on the other hand I have Microsoft 2013 in my pc but no map option is there as well, tell me any solution plz
reply

Kevin do you have any idea to sell online class Globally for free?
I am a piano teacher planning to give my class globally
Any idea for free advertising?

reply

Thank you for sharing this amazing presentation Kevin, but for the filter function unavailable people, is there any other function instead?
reply
Add a review, comment






Other channel videos