Forum Discussion
Dynamic Chart not Working on Filter Array
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.