Pat

In other news, Republican is a stupid fucking asshole.

Good article, thanks for posting.

I had heard that Canada was a lentil powerhouse, so I set about finding a supply of black beluga lentils locally. (These are like the French ‘lentils de puy’ that stay whole when cooked and have a great texture - quite expensive when imported from France.) I found a shop in a farming community about an hour away, but when I got there I found I was buying their last 2 bags, and that they had discontinued that product. I’m stocked up now but don’t know if I’ll be able to get them again, despite being next door to Saskatchewan here in Alberta.

It’s a great example of the importance of supply chains - abundant resource relatively nearby, but largely unavailable nevertheless.

What you’ve found is probably sufficient if you have a small amount of data or only need this type of display rarely.

Another approach to solving this would be to create a date table listing all of the date units between the start and end of your timeline and represent those as having no value. When you add your values to this data set you ensure proportional spacing, as every date unit in the set will be represented. This type of work is much easier to do using Power Query, if you have access to that Excel add in.