In this post, you’ll learn how to use the VLOOKUP With Wildcard in Google Sheets.
Tag: Google Sheets
Web traffic chart with dynamic banding in Google Sheets
This is a simple but effective technique for adding dynamic bands to your charts, which are useful to highlight specific parts of your chart.
For example, in this chart of website pageviews, I’ve added bands to show weekdays or weekends and make it easier to see the changing trends.
Continue reading Web traffic chart with dynamic banding in Google Sheets
Creating A D3 Chart With Data From Google Sheets
In the following image, I have two browser windows open. On the left, a Google Sheet containing a simple table of data. In the right browser window, a web page with a d3 chart that displays the data from the Google Sheet and can be refreshed dynamically when the data changes.
Continue reading Creating A D3 Chart With Data From Google Sheets
Save time with this custom Google Sheets, Slack & Email test scoring bot
You’ve marked your students’ test scores and recorded it all in a beautiful Google Sheet.
You’ve dotted your i’s and crossed your t’s, checked your spelling, and made sure all your scores are ready to go.
Now comes the tedious part, copying and pasting each student’s scores and feedback into an email or Slack message to send back to them.
Wait, there’s a better way!
With a little bit of upfront effort using Google Apps Script, you can build yourself a custom Google Sheets Slack/Email app that can automate that whole final step for you.
Besides being useful, it’s also pretty fun to post stuff from your Google Sheet direct to Slack!
Continue reading Save time with this custom Google Sheets, Slack & Email test scoring bot
Create A Dynamic Chart In Google Sheets With A Drop-Down Menu
In this post, I’ll show you how to create dynamic charts in Google Sheets, with drop-down menus.
I get lots of questions on how to add interactivity to charts in Google Sheets. It’s a great question that’s worthy of a detailed explanation.
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 Google Sheets drop-down menu to control a dynamic chart.
Continue reading Create A Dynamic Chart In Google Sheets With A Drop-Down Menu