MicrosoftWOW! I did it
Dynamic Array works in line chart as supposed but You have to follow some strict rules to build
1. step - create table (maximum 3 rows) - in my example
T / X / Y
1 / 1 / 1
2 / 2 / 2
3 / 3 / 3
Select cells below X and Y (B2:C4) and insert smoth line x-y chart
result will by blue nice line
THEN create name range LineX = $B$2:$B$4
THEN create name range LineY = $C$2:$C$4
( you can use select and name box for that)
THEN click on the blue line and change the series formula on formula bar
Replace $B$2:$B$4 with LineX and $C$2:$C$4 with LineY
So long this works
NOW
change T column (remove 1-2-3 first) with formula =sequence(20;;0;0,1)
change X column (remove 1-2-3 first) with formula =sin(a2#)
change Y column (remove 1-2-3 first) with formula =sin(a2#) * cos(a2#)
NOW
edit range name definitions
LineX = Sheet1!$B$2#
LineY = Sheet1!$C$2#
OK - and diagram changes accordingly 🙂
now change formula in A2 replace 20 with 200 and
IT WORKS
So conclusion - DA ranges works with line diagram well!
