Forum Discussion
Solved
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.
Yes, Semi-Annual Enterprise is far behind other channels. It is updated with new functionality twice per year, in Jan-Feb and Jun-Jul. You may check details here Release notes for Semi-Annual Enterprise Channel releases - Office release notes | Microsoft Learn. Thus on this channel is only to wait, some chances dynamic array charts will be added in couple of months. But not necessary, it could happens next year.
Of course, another option is to ask your IT update you on Current or Monthly Enterprise channel. Here is all depends on company policies. Main reasons could be loss of compatibility with other users and adding bit more headache to IT with support of users on different channels.
- This is a weird one. I have still not got this feature even though I am on monthly enterprise. MS say it's part of 2210 and here I am on 2306 with no sign of this feature yet. I didn't have it, even back in 2210 last year. I get features being deprecated on Beta which I have at home but the lack of it is super annoying given the number of dynamic arrays that are getting built.
