#ExcelPedroWave

🔝To translate this blog post to your language, select it in the top left Google box.

This article is dedicated to today's opening of the Paris 2024 Olympic Games.

This month of July I've written a couple of articles in Spanish about charts with the image of the Eiffel Tower and the Olympic rings, which you can read here:

• Search results for Eiffel | #ExcelPedroWave

I now publish the English version of my Animated Olympic Chart in Excel, with the following features:

1) The animation starts/stops by clicking on the Olympic torch.

2) The animation depicts the Eiffel Tower's 27-month construction period.

3) Shows the 5 interlocking Olympic rings, with one color per continent.

4) The 3 Olympic Games held in Paris took place in 1900, 1924, and 2024.

5) The Olympic rings move automatically.

6) Manual movement of the Olympic rings with a vertical scrollbar.

7) Animation translation into 6 languages: Spanish, English, French, Italian, German and Portuguese.

8) Animation speed control with a dropdown in cell Z5: 1 to 9, minimum to maximum speed respectively. (*)

9) Version compatible with all desktop versions of Excel. (*)

The last two features, marked with (*), are new improvements to this version of the Animated Olympic Chart in Excel.

Download the Animated Olympic Chart

The Animated Olympic Chart is compatible with all desktop versions of Excel, from Excel 2010 to Excel for Microsoft 365.

Download the latest version from one of these links:

• Microsoft OneDrive: Animated Olympic Chart - PW1.xlsm

• Sites Google Drive: Animated Olympic Chart - PW1.xlsm

Macros in the downloaded file are blocked by default. To unlock macros you must modify the File Properties following these instructions:

• Macros from the internet are blocked by default in Office - Microsoft 365 Apps | Microsoft Learn

Open the file and press the button: Enable Editing when the PROTECTED VIEW prompt appears.

Press the button: Enable Content when the WARNING appears SECURITY Macros have been disabled or part of the active content.

Sheets are protected without password, so you can study the formulas and analyze the chart protected by the macro: ProtectChart.

ATTENTION: You can modify this Excel workbook respecting this license:

CC BY-NC-SA 4.0 Deed | Attribution-NonCommercial-ShareAlike 4.0 International | Creative Commons

Video with the Animated Olympic Chart

The video presents the Animated Olympic Chart, ideal for those without a compatible Excel version or who prefer not to download the file.

This summer we will find out the number of Olympic medals 🥇🥈🥉 that athletes get in Paris.