Pivot Chart: Filtering series data

Hi there,

I'm pretty new to Excel so apologies of this is really simple, but I cannot seem to find a solution anywhere. Maybe I am using the wrong terminology.

Untitled-1.jpg

Here is my pivot table, as you can see there are 3 series but I would like to have around 20. This begins to look very cluttered so wondered if I could insert a filter so I can select/deselect certain series? This is so I can view certain series at one time without editing the values in the pivot table.

I would be very grateful for any help at all.

(and if you are wondering about the subject matter I am a conservator at a large library and we are trapping and recording pests that may be harmful to our collection)

Thanks!

Thank you. I will try out the slicers and let you know how it works. I have attached the workbook. There isn't much data in there (only for the 3rd quarter of this year), but will obviously be adding more data and also expanding the worksheet year on year.

thanks for the help.

Thank you very much.

I can see how slicers can be very helpful but still cannot get them to work the way I want to. (They may not do). If you take the image I previously uploaded as a reference I wish to be able to view that chart and to select/deselect certain series for comparison(eg view 'sum of silverfish' alone, or view 'sum of book louse' and 'sum of woodlice'togther to compare). I hope to do this wotjout editing the chart each time i wish to view a different comparions. I hope that makes things clearer and that maybe there is a simple solution.

Many thanks

Thank you very much for your reply.

I see. So does this mean I could have a intermediary table that transforms my data into 'normalised' data? Or would this be very difficult?

I can see a problem being that there may be a number of different insects in one location/trap

I ask as the end goal to make the data easily accessible by making it visual, via charts. The 'Imput' tab makes the input of data easy using forms (to me it does anyway).

Thank you.

Apologies for the late reply.

Thank you very much. I can work much better with this data and it does exactly what I need it to do. I am just unsure how to run the macro myself, I have tried but keep getting an error 'subscript out of range'. Could you help me out with this or is there a thread you could direct me to?

Thanks again!