ExcelBanter - Pivot Table Lay Out

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Pivot Table Lay Out (https://www.excelbanter.com/excel-worksheet-functions/51449-pivot-table-lay-out.html)

Pivot Table Lay Out

Does anyone know if it is possible to chnage the layout of the "Data"
section of a pivot table in excel? In Access, when you run a pivot
form, you can have multiple data points shown side-by-side (i.e. Count
& Sum). In excel, it stackes these on top of each other.

Random Poster

Pivot Table Lay Out

wrote in news:1129819163.221301.52100
@z14g2000cwz.googlegroups.com:

Does anyone know if it is possible to chnage the layout of the "Data"
section of a pivot table in excel? In Access, when you run a pivot
form, you can have multiple data points shown side-by-side (i.e. Count
& Sum). In excel, it stackes these on top of each other.

It can be done. Actually, I wish it was the default position. After you
create the table, drag the "Data" label to the right, towards the column
field region. Watch the mouse icon, it should change when you get to the
right spot.

-RP

Roger Govier

Pivot Table Lay Out

Hi Neil

Just Drag the Data Button and drop it onto Total and you will get the
columns side by side.

Regards

Roger Govier

wrote:
Does anyone know if it is possible to chnage the layout of the "Data"
section of a pivot table in excel? In Access, when you run a pivot
form, you can have multiple data points shown side-by-side (i.e. Count
& Sum). In excel, it stackes these on top of each other.

All times are GMT +1. The time now is 11:20 PM.