I downloaded your three worksheets and it appears two are identical and the third is very different. First, I would not recommend doing a stacked bar chart for three different measures. For example, I would not recommend doing a stacked bar of quantity, sales, and profit. If you wanted to do a stacked bar chart of sales across three categories, that makes sense, but three different measures should probably remain in three different bar charts. Now if they are measuring the same thing, i.e. your F2 category is measuring, for example, quantity in all three sheets, then you could simply union them then do a stacked bar chart on the values of those three sheets (tablename) on detail.
If you can provide more information on whether the F2 value is the measuring the same thing or different things, that would be helpful.