Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 104
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for gurus that knows show and hide functions on a pivot table? [email protected] Excel Worksheet Functions 0 September 3rd 06 05:25 PM
Pivot Chart - show 1 row value, but also showing percentage of who NewChris Charts and Charting in Excel 0 August 30th 06 07:54 PM
Show values in formula instead of cell reference pnorgate Excel Worksheet Functions 6 August 20th 06 09:31 AM
How do I show the Grand Total on a Pivot Chart? Scott_F Charts and Charting in Excel 1 October 26th 05 04:48 AM
Using Pivot Charts, how to hide field values in second level filters? elrao Excel Discussion (Misc queries) 1 June 17th 05 10:22 AM


All times are GMT +1. The time now is 04:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"