Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to show actual values in a pivot grap/table
Hi
Can anyone help me with this - I can't get it working. I have at data list like the following Month Week Day New Working Standby 10 44 29 0 0 0 10 44 30 6 1 0 10 44 31 6 1 0 11 44 1 6 1 0 11 44 2 6 2 0 11 44 3 5 2 0 Where New, Working, Standby, ... are a track of the current numbers of each of these states. What I want is to put these data into a PivotTable/graph showing the progress of these states: Data Month Week Count of New Count of Working 10 40 13 13 41 14 14 42 14 14 43 14 14 44 7 7 10 Total 62 62 11 44 7 7 45 14 14 46 14 14 47 14 14 48 11 11 11 Total 60 60 12 48 3 3 49 14 14 50 14 14 51 14 14 52 14 14 53 3 3 12 Total 62 62 Grand Total 184 184 My problem is that the data seem to have to be summed, max'ed, min'ed, etc. What I want is it to display just the values as is above and the lable as well - how can that be done |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for gurus that knows show and hide functions on a pivot table? | Excel Worksheet Functions | |||
Pivot Chart - show 1 row value, but also showing percentage of who | Charts and Charting in Excel | |||
Show values in formula instead of cell reference | Excel Worksheet Functions | |||
How do I show the Grand Total on a Pivot Chart? | Charts and Charting in Excel | |||
Using Pivot Charts, how to hide field values in second level filters? | Excel Discussion (Misc queries) |