Dynamic Histogram

[cas8100]

Hi All. I am trying to create a dynamic histogram and have come across some new territory. Normally, I use the histogram function in the Data Analysis Add-in, but since I am seeking a dynamic chart, I have built the histogram using an array of the frequency() function. My issue is that I am trying to apply filters to the data set, but I can't get the values in the frequency array to recalculate based on the filtered data. I am using a general column chart to graph the bins/frequency values.

I know that the issue is more of a "formula" type issue than it is a "charting" one, but I posted in this forum because I am seeking a chart output. Please take a look at the attached file - there are two worksheets, a histogram worksheet, and a data worksheet.

My goal is to filter by Group (A,B,or C) in the Data worksheet and have the chart update based on filter. *Ideally, I would like to place the search filter in a combi box on my chart, but baby steps, right?* Can anyone please help me figure out why this frequency array won't update based on the filter?

Thanks for any help,

Carl

[cas8100]

My apologies for the duplicate post in the same forum. I marked the thread as "Solved" and attempted to copy it to the "General" Forum, but it ended up right back here.

[shg]

Duplicate post