visualiation problem

hello   i have a column chart which over 200 columns i would like to group all of this colums into one and create average. but also i would like to use a filter so once i filtered it will show like...