Pie chart from custom ranges

I'm building a production report. Ithas eight horizontal fields of data containing daily productionnumbers. To show the distribution of work performed on any given dayit has multiple scrolling pie charts that use the INDEX function. Iwould like to add a pie chart that allows the user to chose a rangeof dates, probably using two drop-down lists of dates (“From”01/01/2016 “to” 02/29/2016). It would reflect the totalproduction of the various entities between and including those dates. I'm building this at home with Excel 2016. It must function inExcel 2007 on the work machines. Can you help, please?