merging two worksheets into one pivot chart

[Kirstykop]

I’m trying to merge to worksheets into one pivot chart. But i someho
don’t get to choose which fields I can put where in the table. If I us
the multiple consolidated option the wrong items are put on th
horizontal axis. What am i doing wrong

 

[Debra Dalgleish]

You're not doing anything wrong. If you create a Pivot Table from
multiple consolidation ranges, as you discovered, you won't get the same
pivot table layout that you'd get from a single range. There's an
example here:

http://www.contextures.com/xlPivot08.html

If possible, store your data in a single worksheet, and you'll have more
flexibility in creating the pivot table.