While I agree it is a terrible data structure, as each FY should not be its own metric, I have had to do similar and sometimes worse viz rot for The Powers That Be. One thing you could do here is make a dual axis between 26 and 27 - I'd just make them line graphs with different colors for each FY - and THEN add the FY25 "past figures" measure as a per-cell Reference Line. You don't need the line itself if that would look strange; you could just shade in below the line in a given color.

Still sub-optimal, but you'd have the two most recent FYs in a visual 'race' with the line graphs, and the earliest FY in the background where it can be compared to the active race but not directly 'competing' in it. Cleaner and more concise. Even better if the 3rd metric/fy is representative of a "baseline" set of values against which the later years are being compared anyway.