I have a google sheet I use for budgets which runs year to year. I usually create a new tab for each year, but the grouping columns feature means I can just hide a completed year which is ideal.

I also display a simple area graph as shown which can track my expected balance.

If I hide a group, the graph will remove that group’s data which is exactly what I want and expect to happen, but it then leaves a graph size which doesn’t match.

This is obviously nothing more than a minor irritation, but I’d love to find a way to solve this so that the graph size adjusts to match the included data. I’m not particularly skilled with App Scripts and such but suspect there is probably a way to do it.

If anyone could help me, that would be amazing.

Thank you