Gapminder Replica in Microsoft Excel. A Gapminder lookalike animated chart in Microsoft Excel, based on the generic Motion Chart Excel Template. The recent article Motion Chart Excel Template provided a generic template for a motion or animation chart in Microsoft Excel. The examples in that post visualized episodes of the Italian cartoon series La Linea La Linea article on Wikipedia. Microsoft Word Find Highlight Color Chart' title='Microsoft Word Find Highlight Color Chart' />Todays article will put the motion chart template to a more serious, business like use a Gapminder replica in Microsoft Excel. For those of you who do not know Gapminder Gapminder is a data visualization software to animate statistics. It was originally developed by Prof. Hans Rosling and his team and Prof. Rosling presented it in this famous TED talk Hans Rosling shows the best stats you have ever seen. Todays article rebuilds this data visualization and animation in Microsoft Excel using exactly the same metrics. As always, the Microsoft Excel workbook is provided for free download. The Features of the Dashboard. I recently read this great quote by Icon. Finder A user interface is like a joke. If you have to explain it, its not that good. Well, if I would be sure my visualization and the interactive features would be fully self explanatory, I shouldnt need this section. But I am not. So here are a few hints what you can do with this dashboard The heart of the dashboard is the Bubble chart on the left side. Like the example presented by Prof. Hans Rosling, it visualizes fertility rate in children per woman on the horizontal axis, life expectancy in years on the vertical axis and the countries as bubbles. The size of the bubbles represent the population of the countries. The bubbles are color coded by continent and the selected 3 countries to be highlighted see belowThe rectangles above the chart visualize the time line and the current year and let you select one specific year by simply clicking on any given rectangle. With the play buttons at top right you can start and stop the animation, move forward or backwards, go to the first or last year. You can also choose whether you want the animation to loop with the checkbox, i. In the highlight section beneath the play buttons you can define 3 countries with the drop down lists to be highlighted in different colors and you can use the Show highlighted countries only checkbox to only display these 3 countries in the chart. The table right to the drop down lists shows the measures of the highlighted countries and visualizes the maximum value of fertility rate and life expectancy with a grey fill color. In the Filter by region section you can select which continents shall be displayed. Like in the highlight section, the table shows the metrics weighted averages of fertility rate and life expectancy, sum of population. Again, the maximum values are marked with a grey fill color. The Implementation. Calculations. In order to keep the calculations as simple as possible, I added a unique identifier to the data a combination of country and year makes it easy to find the relevant data. Most calculations are pretty simple formulas, mainly INDEX, MATCH and IF. Nothing new under the sun. The most relevant calculation for the chart is the column Filter on the calculation worksheet which defines which countries will be displayed in the chart and which wont. The only complex part are the array formulas to calculate the weighted averages. The formulas are creating a vector with the product of the measure and the population for each relevant country and year, sum this vector up and divide the result by the sum of population in the given continent. They may look complicated but as soon as you know how arrays work in general, they should be easy to understand. Bubble Chart. The chart is a standard Excel Bubble chart with one data series for each continent, one for each highlighted country and a scale dummy series to keep the size of the bubbles in relation to the population of all countries in the data, even if a filter is active, i. Animation. Not much to say here, I guess. Call Of Duty 4 Says Downloading Game Settings Tuner on this page. The workbook is based on the generic Motion Chart Excel Template. If you are interested in the details, please have a look there. The animation control parameter in the Gapminder replica is the year of course. The Interactive Time Line. This is the only part of the workbook which needs additional VBA code. Each of the rectangles has a certain shape name e. Rectangle1. 95. 0 and the sub Click. On. Time. Box is assigned to each rectangle. The sub identifies which rectangle has been clicked on using Application. Caller, changes the value of the current year, updates the fill colors and stops the animation. Only 2 subs with only 5 lines of code. This should be easy to understand. The Download Link. When you installed Microsofts Word Flow keyboard on your iPhone, you probably thought it was an app or extension. Turns out, it was an experiment, an. Microsoft Excel Questions including How do you display the square root symbol on the screen using Microsoft Excel and What is a column. How to create flowcharts in Microsoft Word 2007, 2010, 2013, and 2016 illustrated with screen shots and samples. Microsoft Word 2007 Toolbars Contents click on a topic to go to that section Home Tab. Here is the workbook for free download Download Gapminder Excel Replica Microsoft Excel 2. Wordle is a toy for generating word clouds from text that you provide. The clouds give greater prominence to words that appear more frequently in the source. Microsoft Word Find Highlight Color Chart' title='Microsoft Word Find Highlight Color Chart' />How to Create a Newsletter with MS Word 2. Steps. 1Launch MS Word 2. Double click the desktop shortcut or click on the Start menu and locate the application in Programs. You must have MS Word downloaded to your PC to locate and utilize it. Create a new document. Click the Office Button located in the upper left corner of the window and select New to start creating your document. Browse the Templates. After clicking New, Word will provide an assortment of document types to use. In the left column of the new window, you will see Templates. You can find a selection of templates under the list Installed Templates. If you cannot locate a suitable template there, search for one under the Microsoft Office Online heading in the same window. Choose an appropriate newsletter template. Select a template that is visually pleasing. Your newsletter should be organized and reader friendly. Select a template that is appropriate and relates to your newsletters nature. Choose a template with the needed space for your information. Apply your information. After you have selected your template, the outline of the template will be shown as your new document. Click and highlight a sample heading such as, Heading 1 or Title. Fill in your newsletter information accordingly. Insert images into your newsletter. Once you have selected an image to use, save it to a recognizable folder in Windows File Explorer. Move the typing cursor to the location you want to place your image, then click the Insert tab located on the top toolbar. Click Picture under the insert tab. Select your desired image in the file explorer. Sometimes you can simply copy and paste the image directly to your document. Replace sample images with your own. Right click the sample image. Select Change Picture. Then select the image you would like to use in the file explorer. Insert charts if applicable. Click on the Insert tab. Next, click on the Chart icon. A new window will appear showing various chart selections. Choose a chart type in the left column of that window. Select the appropriate specifications for your chart. Microsoft Excel will open in a new window. Apply your chart data accordingly. Close the Excel window and click OK in the chart window. Your new information will be inserted into your newsletter. If you wish to change the chart type or style, click on the chart, then find the chart editing under the insert tab. List correct information. Include the Name, Date, and other vital information to your newsletter. Make sure to cover all important topics required for the document. Make the newsletter visually pleasing. Make sure to utilize vibrant and attractive color schemes to attract the audience. Organize your document structure for an easy read. Make your newsletter pop and stand out to catch ones eye. Revise and edit. Utilize the Spell Check button located under the Home toolbar. This will show any spelling or grammatical errors. Print a rough copy of your document to further review and edit. Try reading your newsletter out loud to yourself to recognize any errors or miscommunication. Have another person read you your newsletter to avoid any other errors. Save your newsletter. Click on the Office Button at the upper right of the window, then select Save As. Select where you want to place the file. Click Save. Make sure to name your file and place it in a file that you can easily locate.