MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot Tables Displaying Data Columns side by side


Posted by Vivi Hanson on September 15, 1999 12:52 AM

I would like to be able to display the result of two data columns side by side, rather than underneath each other. Is it possible?
Thanks
Vivi


Posted by Dave on September 28, 1999 2:16 PM

You can achieve this by dragging the grey data field up and to the right slightly. (If you don't have enough room, insert a row or two at ROW A.
See examplse of what it will look like at Mr Excels site, http://www.mrexcel.com/tip015.shtml

Posted by Vivi on October 08, 1999 12:37 AM

Hi Dave - you're a star!! Thanks very much. sorry i didn't reply earlier, but was on holiday.
Thanks again - Vivi