Excel tutorial: build a dynamic bump chart of the English Premier League
A data visualization of the history of the Premier League through a dynamic, Excel bump chart. This is an in-depth how-to article showing you how to create your own version.
Search Results for: vlookup
Creating Dynamic Charts In Google Sheets With Drop Down Menus
Dynamic charts can really enhance reports and dashboards, allowing for more information to be conveyed in the same amount of screen space. This article will show you how to use the data validation method to make a dynamic chart.
Excel-fficiency: 10 tips for boosting productivity in Excel
10 tips for boosting productivity in Excel, including custom lists, Excel Tables, named ranges, formula auditing and macro recording.
Excel tutorial: Building a dynamic, animated dashboard for U.S. political data
Who doesn’t love a dynamic, animated Excel dashboard? Here’s one I’ve been working on recently, a data visualization of historical U.S. political data, showing party trends, state populations and sitting presidents over time: In the following post, I delve into the details of how I created this dashboard. It’s not a full cell-by-cell account of … Continue reading Excel tutorial: Building a dynamic, animated dashboard for U.S. political data
10 Techniques for building a Google Sheets Dashboard
Learn the techniques to build powerful, free business dashboards directly in Google Sheets. Gather data through forms, transform data with formulas and create insightful visualizations you can share with friends and colleagues.