Master Business Charts in Excel with our course https://link.xelplus.com/yt-bizcharts-course

In this lecture you learn how to visualize key performance indicators (KPIs) by geographical locations. The best part is that you can do this on any version of Excel and you can use any map you like.

Here's what you'll explore:
▪️ Basics of Scatter and Bubble Charts: Recap the fundamentals of scatter plot and bubble charts as a foundation for more complex visualizations.
▪️ Creating Geographic Bubble Charts: Learn step-by-step how to create a bubble chart that represents KPIs such as sales revenue across different geographical regions and countries.
▪️ Customizing Your Chart: Discover how to adjust the bubble sizes to represent data accurately and how to place data labels for clear readability.
▪️ Initial Map Setup: Understand the initial steps required to set up your map, including pinpointing locations using X and Y coordinates and ensuring your axis scales are fixed.
▪️ Flexibility with Maps: Find out how to use various types of maps, including company-specific or clip art maps, to suit your visualization needs.
▪️ Practical Data Label Adjustments: Get tips on formatting data labels to ensure they are visible regardless of the bubble size.
▪️ Reusable Map for Multiple KPIs: Learn how the initial setup effort pays off by allowing you to reuse the same map for different KPIs in future projects.

My Online Excel Courses ► https://www.xelplus.com/courses/

Excel 2016 comes with a new feature called 3D maps. It's a fancy new addition to Excel that allows you to present your data on a map and even create a mini movie out of it. But sometimes a simple 2D graphic is the best messenger. This lecture shows you how you can easily show your values (KPIs) on any map.

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel