software

Is it possible to set up a pivot table from the wizard with many data fields
to go horizontally across the page rather than vertically down the page? (eg
total sum, average, max, min in columns B-E rather than rows 5-8).

Thanks

Not sure if this can be done using the Wizard, but once you've set up
your table and begun adding data, drag the gray quot;Dataquot; box to the right
field quot;Totalquot; I think. This will place your data in separate columns
instead of rows. As you drag new items to the data field it will
populate a new column.Just to add to Jim's reply...

Debra Dalgleish has the same instructions (with pictures!):
www.contextures.com/xlPivot02.html

jim wrote:
gt;
gt; Not sure if this can be done using the Wizard, but once you've set up
gt; your table and begun adding data, drag the gray quot;Dataquot; box to the right
gt; field quot;Totalquot; I think. This will place your data in separate columns
gt; instead of rows. As you drag new items to the data field it will
gt; populate a new column.

--

Dave Peterson