The Complete Guide to Installing. Row of the pop-up window. How to Install. With Excel and VBA tutorials & tools to help improve your Excel.

• Pop Tools For Excel

Where is Chart Tools in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365

• Downloading PopTools. Current version is 3.2 (build 5). Released September 22, 2011. The easiest way to install PopTools is to download the above executable setup file (~2.8 Mb).
• Excel 2016 supports the use of Office Add-ins to help you build. To use any of these Office Add-ins in Excel 2016, you first need to install them by following.

Charts are quite vivid to help readers understand presenting data and analysis. However, the Chart Tools seem be hidden in Ribbon. Here offers two methods to find out the Chart Tools in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365.

Familiar way to seek Chart Tools if you have Classic Menu for Office

If you have installed Classic Menu for Office on your computer, you will find out that your Microsoft Excel 2007/2010/2013/2016/2019 is so familiar with Excel 2003 that it is easy to find out commands and functionalities:

• Click the Insert drop down menu in main menus;
• Click the All Chart Types… item to add a chart;
• Select the chart, you will view three extra tabs appear in Ribbon: Design tab, Layout tab, and Format tab. These tabs will help you format and edit your charts.

Figure 1: Find out Chart Tools from Classic Menu

Please note that as soon as the chart is deselected, these tabs disappear.

Seek Chart Tools in Ribbon if you do not have Classic Menu for Office

• Click the Insert tab;
• Go to the Chart Layouts group;
• Select one chart type and insert a chart into worksheet;
• Select the chart, and then Design tab, Layout tab, and Format tab appear in the far right of Ribbon. With these tab, you are able to edit your chart.

Figure 2: Seek for Chart Tools from Excel 2007/2010/2013/2016/2019 Ribbon

More Tips for Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365

Classic Menu for Office

Brings the familiar classic menus and toolbars back to Microsoft Office 2007, 2010, 2013, 2016, 2019 and 365. You can use Office 2007/2010/2013/2016 immediately without any training. Supports all languages, and all new commands of 2007, 2010, 2013, 2016, 2019 and 365 have been added into the classic interface.

Screen Shot of Classic Menu for Excel

Many times it happens that you need to quickly visualize your data on a map but you don’t have a time to play for hours with ArcGIS or QGIS to make it look good. In this tutorial I’ll show you how make an awesome looking map in Excel in under 5 minutes with a free plugin called PowerMap (formerly GeoFlow).

1. Download and install the plugin.

Of course the first step would be to download and install the plugin from Microsoft website. You should download it and install without any issues. Initially the plugin was restricted only for MS Office 365 subscribers and owners of an expensive MS Office Professional Plus suite but recently it has been released for all MS Excel 2013 users. Both 32bit and 64bit Windows version are supported but it will work only with Excel 2013 (no previous Excel version is supported). It won’t work on any other operating system though. If you successfully install the plugin, you should be able to see it in your Excel under the “INSERT” tab. If you don’t see it you might need to activate it in Add-Ins menu. To do that go to File -> Option -> Add-Ins. You should the following window: In the dropdown list on the bottom of the window select COM Add-ins and click GO. Now select Microsoft Power Map and click on OK button to activate it. Now everything should work fine. The most difficult part is behind us:). Let’s start mapping.

2. Prepare your data.

Now its time to prepare your data. Power Map gives a couple of options to visualise it. The most obvious is to use coordinates. In this method you need to have two separates columns for latitudes and longitudes. There are a couple of cool things you can do with that and we will cover it in the future #GeoawesomeHoTo. Today lets focus on another great option of the plugin – geocoding.

Geocoding is a process which allows you to pinpoint a geographic location based on a description e.g. address, city name, postal code, country name etc. For the purpose of this tutorial I took a list of the largest agglomerations by population from Wikipedia. Selected the table in a web browser and copied it directly to Excel. Than I pressed “Text to Columns” button in the DATA tab and I came up with the following table.

Geocoding will allow me to show a phenomena on a map based on a city or a country name. It will automatically connect the record to a centroid of a city or a country without a need to give a geographic coordinates.

This is it. Now we can start mapping:).

3. Select you data.

Now you just need to select the data you want to map, in my case it would be the whole table, go to INSERT tab, and click on a “Map” icon, which we’ve added to the menu at the beginning of the tutorial. Click on “Launch Power Map” and here we go.

4. Create a map.

The Power Map window will pop-up on your screen. Below you can see that plugin automatically detected two parameters from our table “City” and “Country”. Based on these two columns Power Map will join the name to a centroid of a Country or a City on our list. In that case we are interested in visualizing the data for cities, so we should select only this option.

After choosing “the geography” click on the NEXT button in the bottom-right side of the page. You will be moved to the settings menu. Now you need to select which data you want to visualize. In our case we’ve got only the Population column, so we should select it. Below that there is a menu to select how you want to visualize the data. There are 5 options:

• Stacked Columns
• Clustered Columns
• Bubble
• Heat Map
• Region

As you can see on the example below I’ve selected the Bubbles.

Now it’s time to play with the visualization and Power Map gives plenty of cool features to do that. You can Flat the map, you can select one of the predefined map themes, add text description (via Text Box) and so one. You can also play with the data visualization. Under settings menu on the right side you can change the opacity, size and thickness of your data points. You can also select a color. The size of the bubbles will change with the map scale so you can select “Lock current scale” if you want to keep make them look the same when you zoom in or zoom out.

5. Save the map

Our map is ready! We can present it directly in Power Map to maintain the interactive features or we can save it as a picture. To do that we just need to press the button “Capture Screen” in the main menu and paste (Ctrl + V) the picture to any graphical editor like Paint or a Photoshop.

Pop Tools For Excel

Here we are. Awesome looking map of the population of 75 largest cities in the world in under 5 minutes! Have fun!