| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot tables - add columns | Excel Worksheet Functions | |||
| Formatting Columns in Pivot Tables | Excel Discussion (Misc queries) | |||
| Pivot tables and dynamic columns | Charts and Charting in Excel | |||
| Pivot Tables - # of Columns | Excel Discussion (Misc queries) | |||
| Pivot tables - inserting columns | Excel Worksheet Functions | |||
Linear Mode
