Forum Discussion
dynamic graph from filter function
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
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