Forum Discussion

cryslot's avatar
cryslot
Copper Contributor
Apr 28, 2023

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. 

DepartmentNameYearly Salary
FinanceGary Miller60270
SalesJames Willard39627
FinanceRichard Elliot29726
SalesRobert Spear93668
FinanceRoger Mun134000
SalesPaul Garza34808
FinanceRobert Marquez134468
ProcurementNatalie Porter45000
FinanceKim West89500
FinanceStevie Bridge21971
ProcurementAndre Cooper80000
FinanceCrystal Doyle185000
ProcurementRobert Musser50454
FinanceDaniel Garrett140000
ProcurementAnn Withers110000
FinancePaul Hill68357

 

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 :

Resources