MicrosoftSomething strange again - Dynamic chart with dynamic ranges works fine but not always
Make a test:
New Workbook
Sheet1 cells A1:A3 "table head" Nr / Name / Value
A2 =SEQUENCE(10)
B2 =TEXT(A2#;"dddd") // replace ; to , - when using english regional
C2 =RANDARRAY(COUNT(A2#);;10;20)
You get Dynamic array filled "nice" table.
now define 2 names (with name box of through formula - no difference)
Names =Sheet1!$B$2:$B$11
Values =Sheet1!$C$2:$C$11
NO Select cells B2:C11 and Insert chart - most simple bar chart
click on some bar and edit on formula =SERIES(;Sheet1!$B$2:$B$11;Sheet!$C$2:$C$11;1)
replace ranges with defined names =SERIES(;Leht1!Names;Leht1!Values;1)
Everything works so long
Now - Edit defined names (Formula/ManageNames)
Names = $B$2#
Values = $C$2#
NOw chart will be dynamic
so try - edit Cell A2 with =SEQUENCE(20) // or something else and see - chart IS dynamic
Problem - I reached is that try to do this same with X-Y line chart and sometime this work sometime nope
