I have three seperate files of data (2014,2015,2016) that have for the most part the exact same column headers. I am trying to pull together a powerpivot with a pivot chart to show my boss by fiscal week (which is a column of a three files) by certain order type(another column in all 3) what were our booking amounts.

I am having trouble understanding the relationships tool getting all that I need into a smooth graph with 53 fiscal weeks as the x axis and amount as the y axis with other filters along the side.