Chart from dynamic array challenge

Hi

(Excel 365 v2512 b19530.20144 Current Channel / Windows 11 25H2)

Charts are definitively not my thing. Spent hours on the following, searching, testing… to no available

The below chart data range is a dynamic array (could be wrong for the desired chart) - named GRAPH_Series on sheet GRAPH_Ranges - similar to the array on the left side of the pic. The arrays dynamically resize according to the 'START Year' & 'TOPN Cat' variables - so far so good

Setting the Chart data range as =GRAPH_Ranges!GRAPH_Series and changing nothing else, the chart updates as expected according to 'START Year' & 'TOPN Cat'. On the other hand if I change anything in the Select Data Source dialog box the chart won't update properly anymore

The expected chart is the same as above with 2020, 2021...2025 (instead of 1, 2,...6) horizontally & D, F, B, A as legend

Thanks & any question please let me know
Lz.