Worlds best Ms Office Tutorial content. Find anything about Ms Office Tutorial on this site.
Change To Bubble Chart In Power Map. From the Fields pane drag. On the screenshot below I have the Change Sign column its a column saying if a change is positive or negative and I want to change the color of the bubbles based on this.
This helps to ensure the bubbles are clearly visible regardless of the style of the map. Then we have to select the Excel file from the location as shown below. You can have values for three types of data like number of products volume of sales and percentage size of market share.
As you can see from the screenshot below we changed the size to 25.
Format Theme of a Map. With Excel Map you can easily replace the bubble shape with an image. In this video I show you how to use a bubble chart in excel to make a map using longitude and latitude coordinates. If you have cities more than 6 or 7 then it is not advised to use this option.