merging two worksheets into one pivot chart

  • Thread starter Thread starter Kirstykop
  • Start date Start date
K

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
 
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.
 
Back
Top