ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Extra columns in Pivot Tables (https://www.excelbanter.com/charts-charting-excel/197228-extra-columns-pivot-tables.html)

lee

Extra columns in Pivot Tables
 
When I add a second data item into the data area in pivot tables, the second
data item appears below the first. Is there any way of making the item appear
in a separate column instead?

Ken Wright

Extra columns in Pivot Tables
 
Just grab the Grey cell marked Data (Probably B3), and drag it to the Column
Fields, eg C3

Regards
Ken....................

"Lee" wrote in message
...
When I add a second data item into the data area in pivot tables, the
second
data item appears below the first. Is there any way of making the item
appear
in a separate column instead?





All times are GMT +1. The time now is 01:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com