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 he

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.


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




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html