file getting too big with charts
 

I've got a file that has multiple tabs, each with two charts tied to dynamic
tables (tables based on pivot chart data and two dropdown lists). The
problem is that the file is getting huge because I have so many copies of
this going on. How can I reduce the file size (30MB)?