May 17 2021 12:28 PM
How do we create a dynamic chart from the new filter function. It almost works perfectly but when the filter changes the number of rows it fails to resize the data array for the graph
May 17 2021 01:01 PM
May 17 2021 01:17 PM - edited May 17 2021 01:18 PM
As an example, If spill is in D5 you may define names
xAxis as =INDEX(Sheet1!$D$5#,0,1)
yAxis as =INDEX(Sheet1!$D$5#,0,2)
and use these names in a chart