Forum Discussion
cryslot
Apr 28, 2023Copper Contributor
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 youtube channel.
Department | Name | Yearly Salary |
Finance | Gary Miller | 60270 |
Sales | James Willard | 39627 |
Finance | Richard Elliot | 29726 |
Sales | Robert Spear | 93668 |
Finance | Roger Mun | 134000 |
Sales | Paul Garza | 34808 |
Finance | Robert Marquez | 134468 |
Procurement | Natalie Porter | 45000 |
Finance | Kim West | 89500 |
Finance | Stevie Bridge | 21971 |
Procurement | Andre Cooper | 80000 |
Finance | Crystal Doyle | 185000 |
Procurement | Robert Musser | 50454 |
Finance | Daniel Garrett | 140000 |
Procurement | Ann Withers | 110000 |
Finance | Paul Hill | 68357 |
Using the Filter formula, I created another set of data that is dependent on a drop down list based on the Department. There are 3 departments from this example, with different number of people from each department. With the data from the filter function, I created a graph and supposedly, when I choose the department from the drop down list, my table would also adjust so there are no more white space or empty spaces in the chart.
But it doesn't seem to work. I don't know what I am doing wrong.
Sample broken chart when I choose Sales :
- cryslotCopper Contributor
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.