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
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.
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.