Quote:
Originally Posted by pistachoo
I noticed 2020 is included in your table but not in your chart; was there a reason for this?
I made a copy of your spreadsheet to muck about with it because spreadshits are fun, and I added 2020 back in to see. I did find that it was starting to look mighty busy as a column chart with that many years included: that gets hard to read!
|
As you (and probably everyone else) had noticed, I left the year 2020 out of the bar graph. This was done intentionally because initially when I just added the 2023 data in, the resulting bar graph had too many bars for each month, and I thought that looked too distracting. So I made the conscious decision to leave one of the years out to reduce visual clutter.
2018 was the initial control year, so it didn't feel right to leave that out.
2019 was the insane, all-time high year, so I can't leave that out.
2022 was the year before the year of the most recent data (2023), so I can't leave it out as it'd make for a good comparison.
2023 was the most recent year that we do not know about yet!
So it came down to ditching 2020 or 2021. With 2020 being the COVID lockdown year, I felt that year was less representative of what the VPD was doing, so I left it out of the bar graph. But I left the data there in case anyone (such as yourself) was still interested in it, and you can play with it as you wish (and have done).