| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Realigning Pivot Data
Hello
At the moment I have three lots of data in my pivot table are they are shown in the same row i.e. one on top of the other. Sum of Allocation 1,257 Sum of Sold 999 Sum of % Sold 79% Does anyone know how I can show the data by columns instead? Thanks -- James. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Realigning Pivot Data
The nice thing about pivot tables is that in general things are easy to move
around. The heading above your 3 Data elements is a grey drop down with the word Data in it. Grab the box and drag it from it's current position in the left hand column and drop along the top in the appropriate row. As you drag the Data box you will get an I-beam indicator letting you see where it is going to position itself... -- HTH... Jim Thomlinson "James" wrote: Hello At the moment I have three lots of data in my pivot table are they are shown in the same row i.e. one on top of the other. Sum of Allocation 1,257 Sum of Sold 999 Sum of % Sold 79% Does anyone know how I can show the data by columns instead? Thanks -- James. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Realigning Pivot Data
Got it thanks Jim. Knew you could move column and row fields just didn't know
it with data! Thanks again James. -- James. "Jim Thomlinson" wrote: The nice thing about pivot tables is that in general things are easy to move around. The heading above your 3 Data elements is a grey drop down with the word Data in it. Grab the box and drag it from it's current position in the left hand column and drop along the top in the appropriate row. As you drag the Data box you will get an I-beam indicator letting you see where it is going to position itself... -- HTH... Jim Thomlinson "James" wrote: Hello At the moment I have three lots of data in my pivot table are they are shown in the same row i.e. one on top of the other. Sum of Allocation 1,257 Sum of Sold 999 Sum of % Sold 79% Does anyone know how I can show the data by columns instead? Thanks -- James. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Realigning | Excel Worksheet Functions | |||
| Distributing Pivot Tables where pivot table data can't be accessed | Excel Discussion (Misc queries) | |||
| Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
| Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
| Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
Linear Mode
