Comparing 3 separate files

[sbobb12]

I have data in one excel workbook but my information is on 3 different tabs. One with Actual, LY, Budget. When I try and gather all the information on the one graph, it makes one of the tabs the lead and keeps the information for the other tabs static.

Example.

Actual vs LY YTD works fine, until I try to bring in product details which are identical for both years. It only breaks the column down for one, not both. So one is showing me the sales by product and the other is showing me total sales. What am I doing wrong?

[v-chuncz-msft]

@sbobb12,

The requirement is not very clear. You might need to check the relationship.