Select and Highlight across an Excel Dashboard
Interactive Excel Dashboard visualizing unemployment rates in the EU. Select a country, filter by age group and gender, and see the selection highlighted across all visuals on the dashboard
Clearly and Simply
Intelligent Data Analysis, Modeling, Simulation and Visualization
Latest posts
London Excel Meetup Workbooks
The workbooks used in my presentation on “Analytical and Interactive Dashboards in Excel” at the London Excel Meetup, September 3, 2020
Visual Workbook Navigation with a Chart Carousel
A Carousel of Charts as a visual and interactive Navigation Control for Microsoft Excel Workbooks
A Neural Network to solve Travelling Salesman Problems in Excel
Artificial Intelligence in Microsoft Excel: watch a Neural Network at work while solving a Travelling Salesman Problem
Excel Oddity using Named Formulas in Charts
With Named Formulas as the Data Source of a Chart Series, Excel does not always plot the values correctly
Animated Races of the 4 Big Football Leagues
Complementing the previous post: Animated Races of the 4 big Football Leagues in Europe: Premier League, Serie A, La Liga and Bundesliga
An Alternative to the Bar Chart Race
An alternative solution to the controversial animated Bar Chart Races in Microsoft Excel
A practical Example for Dynamic Storyboards
A more practical use case for Dynamic Storyboards in Excel: support the Animation of 2-dimensional data by showing the years before and after the current year on a Storyboard
Dynamic Storyboards in Excel
How to create a Dynamic Storyboard of Small Charts (similar to Small Multiples, Panel or Trellis charts) in Microsoft Excel
How to handle Line Charts with many Data Series
2 Alternatives to avoid cluttered Line Charts: a Band Chart and an interactive Line Chart highlighting one selected data series when hovering over