Is there a way to automatically resize a heatmap if the height is too long for the screen? In other words, when a view is set to "standard" is it possible to dynamically set it to "fit height" whenever it it too large for the view? The reason why I want to keep the original sizing to standard is to avoid spaces between rows in the heatmap. I could set the view to "fit height" to solve this problem, but then this causes large whitespaces in between rows, which I also want to avoid.

I have an example dashboard attached using the world indicators sample data. In Sheet 12, if you filter to region, the heatmap is fine, but when the filter is set to (All) the scrollbar shows up (although, if your screen is somehow large enough you might not see it).

This works, but is there a way to make the axis look like a normal (continuous) date? I have so many dates in my dataset that it becomes very cluttered if you make the date range too wide. If there was a way to make the dates discrete days, but have the axis display years I think that would be good in my case.