dynamic graph from filter function

%3CLINGO-SUB%20id%3D%22lingo-sub-2361987%22%20slang%3D%22en-US%22%3Edynamic%20graph%20from%20filter%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2361987%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20we%20create%20a%20dynamic%20chart%20from%20the%20new%20filter%20function.%26nbsp%3B%20It%20almost%20works%20perfectly%20but%20when%20the%20filter%20changes%20the%20number%20of%20rows%20it%20fails%20to%20resize%20the%20data%20array%20for%26nbsp%3B%20the%20graph%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2361987%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2362121%22%20slang%3D%22en-US%22%3ERe%3A%20dynamic%20graph%20from%20filter%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2362121%22%20slang%3D%22en-US%22%3EHere%20is%20an%20article%20on%20how%20to%20create%20a%20dynamic%20chart%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Ftroubleshoot%2Fexcel%2Fdefined-names-to-update-chart-range%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Ftroubleshoot%2Fexcel%2Fdefined-names-to-update-chart-range%3C%2FA%3E%3CBR%20%2F%3EThis%20article%20uses%20the%20OFFSET%20function%20in%20the%20Name%20Manager%20but%20you%20can%20use%20the%20new%20FILTER%20function%20instead.%20BUT%20you%20still%20need%20to%20create%20the%20name%20and%20reference%20the%20name%20in%20the%20xseries%20and%20yseries%20as%20described%20in%20the%20article.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2362190%22%20slang%3D%22en-US%22%3ERe%3A%20dynamic%20graph%20from%20filter%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2362190%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1056168%22%20target%3D%22_blank%22%3E%40FinUrb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20an%20example%2C%20If%20spill%20is%20in%20D5%20you%20may%20define%20names%3C%2FP%3E%0A%3CP%3ExAxis%20as%26nbsp%3B%3DINDEX(Sheet1!%24D%245%23%2C0%2C1)%3C%2FP%3E%0A%3CP%3EyAxis%20as%20%3DINDEX(Sheet1!%24D%245%23%2C0%2C2)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eand%20use%20these%20names%20in%20a%20chart%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

@FinUrb 

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