What version of Excel are you using?
Do you have a filter on the values?
alanas wrote:
Hi all,
I have a PivotTable:
1st col: 2nd col:
Dates(Row fields) Sales(Data fields)
01.01.08 100
01.02.08 150
01.03.08 0
01.04.08 120
And that one 01.03.08 row is automatically hidden, because it contains zero
value in its data field, consequently it will not be shown in diagram also.
Could you suggest me How can I show it in my PivotTable (Diagram)? The point
is that it's shown and checked in filter list, but anyway it's not shown in
result PivotTable.
thanks
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html