Analyze some Data

I am looking for some help setting up some metrics based on two different data sets and visually displaying them in graphs. I want to do this using pivot charts, so that I can add additional monthly data and update the pivot table and chart easily. I also want the charts set up so that I can easily filter the date ranges from Year, to Quarter to Month without having to have multiple charts or select new data. I want the following results : 1) ECO Data Tab = # of "ECO Numbers" vs. "Cycle Time" (Yearly, Quarterly, Monthly) 2) Object Data Tab = # of "ObjectType" per (Year, Yr-Quarter, Yr-Month) 3) Object Data Tab and ECO Data Tab combo =# of "ObjectType" vs. "Cycle Time" (Yearly, Quarterly, Monthly) Charts will be combo with Volumes Bar Charts and Cycle Times Line Charts Each line item in each tab is a separate item.