Hi everybody!
Is it possible to display the error #N/A instead of nothing (empty cell) when there's no data? The reason is that I'm trying to generate several plots directly from the Pivot Table and I want them to ignore the empty cells, and as far as I know the only way to do this automatically is by filling those cells with #N/A error value.
By the way, the Pivot Table is calculating Averages, so when there's no data it shows by default the error #DIV/0 which is NOT ignored by charts...
Please help!!
Cheers
Is it possible to display the error #N/A instead of nothing (empty cell) when there's no data? The reason is that I'm trying to generate several plots directly from the Pivot Table and I want them to ignore the empty cells, and as far as I know the only way to do this automatically is by filling those cells with #N/A error value.
By the way, the Pivot Table is calculating Averages, so when there's no data it shows by default the error #DIV/0 which is NOT ignored by charts...
Please help!!
Cheers

Last edited: