Getting PivotTable to show ZERO instead of a blank cell

[taft584]

I'm attempting to make a chart for a school project and have just discovered PivotTables. I have managed to make it produce every graph I can dream of, but I am having trouble making a table format itself the way I want it to. Right now if there is no data for a given row/column, that cell shows up as blank. Is it possible to make it show a zero value instead? Otherwise I fear it will be horrible to read on paper.


I have to apologize, I am pretty ignorant with excel beyond making it do my calculus homework. Up until this point I have done everything through trial and error.

 

[Smitty]

Welcome to the Board!

You can right-click anywhere in the PT, then select Pivot Table Options-->Layout & Format-->For empty cells show.

HTH,

 

[taft584]

That has to be the fasted, most helpful forum reply I have ever got! thanks man!

I feel like an idiot, I must have looked past that about 50 times.

EDIT: also, should I edit this to say [SOLVED], I know some help forums are quite particular about that.

 

[Smitty]

EDIT: also, should I edit this to say [SOLVED], I know some help forums are quite particular about that.

Nah, we're not that particular. All we ask is that if something works for you, you let everyone know.

 

[emka207]

I need to show an average column on my Pivot Table, where blank cells is treated as zero.

However, It seems that the average column doesn't consider the blank cells even though I have shown them as zero.

Any tips on this?

Thank you.
Cheers.