Ahem In my defense, the way I did it wasn’t totally terrible. The dates are all gathered from other sheets, the chart is generated automatically with conditional formatting, and it’s locked so there’s no moving of cells or changing the colour manually. Don’t hate me.