Chart Question reference filtering data

Originally Posted by lilsnoop

Thanks Bryan! You were correct, I wanted the data from Column G and for charting purposes the names of the various crimes in Column H which has them listed up to (H6 to H19). Thank you for your advice and time!

np - I think you confused yourself with the hand-written formula, it is easier when you use a 'formula fill'able formula, but, good to see your problem resolved, and thanks for your response.

---