Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Data
I have my pivot table shown my data as % of row but I would also like to see
the number can I do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Data
"saz2369" wrote: I have my pivot table shown my data as % of row but I would also like to see the number can I do this? What I would like to show is on my pivot stacked column chart I want the y axis showing the actual numbers and the columns showing the difference in % for that column. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Data
You can place the same field into the pivot area multiple times so the answer
is yes. Just drag the same field into the center and you are good to go... -- HTH... Jim Thomlinson "saz2369" wrote: I have my pivot table shown my data as % of row but I would also like to see the number can I do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Data
Thanks for your help, on my stacked column pivot chart I want to show on the
data labels the percentage that make up the column and on my y axis the actual number can I show this? "Jim Thomlinson" wrote: You can place the same field into the pivot area multiple times so the answer is yes. Just drag the same field into the center and you are good to go... -- HTH... Jim Thomlinson "saz2369" wrote: I have my pivot table shown my data as % of row but I would also like to see the number can I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
Data Area of Pivot Table and Pivot Charts | Charts and Charting in Excel |