Configuring and using BING and Bubble Office Apps in Excel 2013

Posted by: Pravinkumar Dabade , on 1/8/2013, in Category Office Apps
Views: 24272
Abstract: In this article, we will use the “Bing Maps” and “Bubble” Office apps in Excel 2013.

Did you know that you can now build a new class of apps for Office 2013 and SharePoint 2013? This can be done by visiting the Office store from where you can download different apps for office 2013. In this article, we will first configure Office 2013 apps in Microsoft Excel 2013. Then we will see how to use these apps in our excel workbook.

 

To configure Office apps in Excel 2013, we will have to download and install the apps. First of all we will open Excel 2013 as shown below –

openexcel

Once Excel 2013 is opened, click on a Blank Workbook. Then click on the “Insert” ribbon. Under the “Insert” ribbon, you will find a dropdown box “Apps for Office”. Click on dropdown arrow and click on the “See All” link as shown below –

 

listallapps

Once you click on “See All”, you will find all the “Featured” apps as shown below –

featuredapps

To see more apps for Excel 2013, click here

You can add these apps for Excel 2013 by clicking on the “Add” link. Once you click on the “Add” link, you will see the details of that app as shown below –

addbutton

Clicking on “Add” button may prompt you to login if you have not already logged in with “Live ID”. I have added a “Bing Maps” app by following above steps.

If you click on “OFFICE STORE” link under “Insert App” a message may appear that says “Please Sign in with a valid profile to see apps” as shown below –

officestoreapp

To sign in with a valid profile, click on the “User” icon on top right hand side of Excel 2013 as shown below –

usericon

Click on Switch Account, Personal and sign in with “Live ID” as shown below

signin

Once you log in, go to “Apps for Office” and click on “Office Store” link. Now you will see “Bing Maps”. Click on “Bing Maps” and click on “Insert” button. The Bings Map will be added into your Excel Sheet.

Now let’s add some data into our Excel Sheet as shown below –

exceldata

Please note that the above data is not accurate and is for demonstration purposes only. Also note that Bing Map app requires the latest browser that is “Internet Explorer 9”. Other browsers like Firefox 12, Safari 5, Chrome 18  are also supported. You can find the list of supported browsers from here http://office.microsoft.com/en-in/support/supported-browsers-in-office-HA102789344.aspx

If you have not installed IE 9, then first of all update your browser. Once you are done, your Bing Map app will show you a tool bar as shown below –

bmaptoolbar

Now select the data from our excel sheet and click on “Plot Locations”. That’s all. Bing map app will automatically refresh the data you selected and display it as shown below –

indiamap

Now if you click on any of the Pie chart, you will see the details of the location –

statedetails

Now click on the “Settings” as shown in above tool bar. In the settings pane, you can change the –

1. Map Type.

2. Multiple Data Point Display.

3. Show Legend.

4. Change the Pin colour.

You can also filter the visualization by clicking on “Filters” from the toolbar as shown below –

filters

Now let’s add a “Bubbles” app by following similar steps which are mentioned above. Once you get the app in our “OFFICE STORE”, insert the same in our Excel sheet as shown below –

bubbleapp

Now click on “Select Table” bubble and select our population table. Once you select the population table, the “Bubbles” app will look similar to the following –

bubbleappdata

And that’s it. With just some clicks and easy configuration, we have used “Bing Maps” and “Bubble” Office apps in Excel 2013.

This article has been editorially reviewed by Suprotim Agarwal.

Absolutely Awesome Book on C# and .NET

C# and .NET have been around for a very long time, but their constant growth means there’s always more to learn.

We at DotNetCurry are very excited to announce the The Absolutely Awesome Book on C# and .NET. This is a 500 pages concise technical eBook available in PDF, ePub (iPad), and Mobi (Kindle).

Organized around concepts, this eBook aims to provide a concise, yet solid foundation in C# and .NET, covering C# 6.0, C# 7.0 and .NET Core, with chapters on .NET Standard and the upcoming C# 8.0 too. Use these concepts to deepen your existing knowledge of C# and .NET, to have a solid grasp of the latest in C# and .NET OR to crack your next .NET Interview.

Click here to Explore the Table of Contents or Download Sample Chapters!

What Others Are Reading!

Author
Pravinkumar, works as a freelance trainer and consultant on Microsoft Technologies. He is having over 10 years of experience in IT and is also a Microsoft Certified Trainer(MCT). He has conducted various corporate trainings on all versions of .NET Technologies including .NET, SharePoint Server, Microsoft SQL Server, Silverlight, ASP.NET, Microsoft PerformancePoint Server 2007 (Monitoring). He is passionate about learning new technologies from Microsoft. You can contact Pravinkumar at dabade[dot]pravinkumar [attherate] gmail[dot]com


Page copy protected against web site content infringement 	by Copyscape




Feedback - Leave us some adulation, criticism and everything in between!

Categories

JOIN OUR COMMUNITY

POPULAR ARTICLES

C# .NET BOOK

C# Book for Building Concepts and Interviews

Tags

JQUERY COOKBOOK

jQuery CookBook