If you have the latest version of Office 365 I found that changing your location cells to a geographical data type in the data tab helps if your Excel isn't initially picking them up.
Fantastic video Karl. Not sure if you are still monitoring comments, but one issue I have is after selecting filters on the slicer, map is still pointing to the entire pivot range, including blank cells, which is causing an error on the map chart. I noticed you didn’t have this issue when selecting Jennifer who only sold in one state. Any tips would be much appreciated!!!
Hi Karl, thanks for the video. it helped me greatly. just an query, i am currently working on india , actually getting data for some cities while not for some can you just help me about what might be the issue there? Thanks for the help in advance.
thank you, buddy its really amazing to use this trick
Karl - thanks that was really helpful. I was stuck on making a map chart from a pivot and this worked like a charm with my existing slicers
My great appreciation for your very important technical video.
Thanks a lot Karl i've a project in Data Analysis and you helped me out ♥
Can you do this for every city in the world??
Thank you so much, this really helped me a lot.
@@chellakamina4255 pleasure
Thank you I’m doing a data analytics project and this really helped me through one of the questions!
Pleasure! There are more videos I have uploaded since.
Brilliant! Thankyou so much!
If you have the latest version of Office 365 I found that changing your location cells to a geographical data type in the data tab helps if your Excel isn't initially picking them up.
Fantastic video Karl. Not sure if you are still monitoring comments, but one issue I have is after selecting filters on the slicer, map is still pointing to the entire pivot range, including blank cells, which is causing an error on the map chart. I noticed you didn’t have this issue when selecting Jennifer who only sold in one state. Any tips would be much appreciated!!!
nice trick
Thankyou ♥️
Hi Karl, thanks for the video. it helped me greatly. just an query, i am currently working on india , actually getting data for some cities while not for some can you just help me about what might be the issue there?
Thanks for the help in advance.
Smart!
Thanx ❤️