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
2 Replies
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
- Here is an article on how to create a dynamic chart:
https://docs.microsoft.com/en-us/office/troubleshoot/excel/defined-names-to-update-chart-range
This article uses the OFFSET function in the Name Manager but you can use the new FILTER function instead. BUT you still need to create the name and reference the name in the xseries and yseries as described in the article.
