Educator and Google Developer Expert. Helping you navigate the world of spreadsheets & AI.
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.
Sparklines are miniature, lightweight charts that exist inside a single cell in your spreasdsheet. They are a quick and easy way of visualizing your data and are especially useful in dashboards. In this post, we’ll explore sparklines in depth in Google Sheets.
A review of 2015, where the main themes were growth both personally and the business. Having a son, teaching at General Assembly and growing this website were the highlights. A look forward to the goals for 2016 – releasing digital products, more teaching at GA and expanding this website. Happy New Year!
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
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.