3-D Frequency Chart in VBA

I currently have a frequency chart (3-D Column Chart) that reports the
frequency of an item within a range and also in what distance that
range appears. I wanted to know if anyone has any suggestions on how to
automate this task.

I first have to locate the distance ranges and then I perform a IF AND
statement to see if the item appears in the distance range then it
copies that item value in a cell if not then return nothing:
=+IF(AND($A1=AA$9,$A1
Then from there I setup a frequency array to get the frequency of the
previous search and what percent range the items fall in:
=FREQUENCY(AA$10:AA$875,$N$10:$N$15)

N10-N15 are my percentages (BINS)

If anyone has any suggestions please pass them on. I already tried to
use the Data Analysis function but I could not achieve what I wanted.