Excel Charts with Drop-Down lists

The original workbook has formulas on the 2nd worksheet that get information from the 1st worksheet and auto-fills the 2nd wroksheet. I don't know how to copy-paste entire worksheets which include formulas. That's why you don't see the formulas in this workbook... Just know they're there. My problem is that I want to create graphs for the data contained in the 2nd worksheet. I only know how to create a drop-down menu using data validation. I read a little about named ranges and the OFFSET funtion but I don't know how to get started with these.