I have attached the workbook I'm using. I need to create a chart that changes as you select a different office from the drop-down menu on the 3rd worksheet. I need the chart to go to the 2nd worksheet and look for the information and give me a graph of the data. I put formulas in the 2nd sheet to give the data I was looking for from the 1st sheet. I don't know how to make Excel paste formulas into another workbook. My knowledge is limited. Could someone help me?