Convert Blank to 0 in Pivot Table Result

[AGreen]

Hi. I have a pivot table (in Excel 2010), that has blanks in the result. In order to chart the results, I want to convert the blanks to 0 so there will be a continuous line. Does anybody know how to do that?

Thanks...

 

[Derek Brown]

Hello and welcome to The Board.
Right mouse-click a cell in the pivot table and select "PivotTable Options".
On the Layout & Format tab, you will find the option to specify a value for blank cells.

 

[AGreen]

Thank you very much. I knew there had to be a way - just couldn't find it. I'll share it here.

Thanks... Aileen