If you look at the example I discussed last week, specifically the Present_Pie and Present_Line worksheets, you might notice that when making pie charts and the single-value line graph, I had three columns for the source data. This is significant,… Read moreUsing concatenate() and if() to improve charts and graphs

Offhand I can think of a number of different ways I could present the data from the daily downloaded statistics project I discussed last week. I could…

One thing I do every month is compile statistics on how many questions have come in to our chat reference service from various libraries. On the one hand, these statistics are automatically generated, so there’s no fussing or worry about… Read moreProject: Statistics from daily downloaded data

In step 6 of last week’s post I suggested that you might want to just delete the formula from any cell that was marking a valid cell as “check”, so you could easily see when you had checked all of… Read moreAdding exemptions to checking for missed data

Most of the time when doing time-based statistics, you’re supposed to have statistics for every unit of time you’re reporting on. That is to say, every hour for hourly statistics, every day for daily ones, every month for monthly, and… Read moreFinding missed data