Forum Discussion
Dynamic Chart not Working on Filter Array
Currently, I am working on creating a dynamic chart in Excel using the filter array function but my chart wouldn't adjust accordingly. Below is a sample table I am using based on Leila's youtub...
Hi SergeiBaklan
Thank you!
I used your file but it doesn't work on mine.
I am using Office 365 and am currently connected to my OneDrive. I wonder why it wouldn't work on my Excel.
I guess it depends on Channel on which you are. Dynamic resizing of charts was introduced few months ago, not sure on which channels it works now. I'm currently on
Alternatively you may use named dynamic ranges like here dynamic graph from filter function - Microsoft Community Hub
Oh. So this explains it. My version is still at 2208. I will ask our IT dept about this. I tried to install latest version but it says I am up to date.
Thank you so much! This was driving me crazy for 2 days now, unable to get some sleep. Only for this to be the cause.
