Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Items Values In Pivot Tables/Charts
How do I show just the values of the data in a Pivot Table/Chart. I seems
that I have to choose a function like sum, max, min, count, etc. In the same way I just want the name of the data item to appear in the Column Fields and not Sum Of 'name' or Count Of 'name', etc. Any help appriciated. /Steen |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Items Values In Pivot Tables/Charts
A pivot table can summarize text values, using one of the function in
the list, but can't display text values from the source data in the Data Area. You could add the field to the Row Area, then use the data area to show a count of each item. Steen wrote: How do I show just the values of the data in a Pivot Table/Chart. I seems that I have to choose a function like sum, max, min, count, etc. In the same way I just want the name of the data item to appear in the Column Fields and not Sum Of 'name' or Count Of 'name', etc. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Items Values In Pivot Tables/Charts
Hi Debra
Thanks for your answer, but I do not understand it. I not familiar with with using Pivot Tables/Graps as you probabely already has guessed :-) I have an excell sheet to keep track of progres in a project which I would like to be able to have in a Pivot Graph/Tabel. The sheet looks like this A B C D E F Month Week Day New Working Closed 11 46 3 9 5 2 11 46 4 9 4 3 11 46 5 8 9 4 .... ,where New, Working and Closed is the number of tasks with that status. I would like a Pivot table/Chart showing the same but it seems that I have to use sum, min, max,... - do you or another person have a clue of how to do this: PIVOT GRAPH: YEAR No Of Tasks ^ 9| x x o 8| x 7| 6| x NEW 5| o o WORKING 4| o - - Closed 3| - 2| - 1| ------------------------------------------------------------------------Time 1 2 3 4 5 6 7 8 9 10 11 12 ... Day 46 47 48 ... Week 11 ... Month MONTH|WEEK|DAY Any help on that? "Debra Dalgleish" wrote: A pivot table can summarize text values, using one of the function in the list, but can't display text values from the source data in the Data Area. You could add the field to the Row Area, then use the data area to show a count of each item. Steen wrote: How do I show just the values of the data in a Pivot Table/Chart. I seems that I have to choose a function like sum, max, min, count, etc. In the same way I just want the name of the data item to appear in the Column Fields and not Sum Of 'name' or Count Of 'name', etc. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
pivot table returning a "value in the data items" | Excel Discussion (Misc queries) | |||
pivot table with selection values not included in the base data | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) |