ExcelBanter - Pivot chart: get rid of zeroes?

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Pivot chart: get rid of zeroes? (https://www.excelbanter.com/charts-charting-excel/134916-pivot-chart-get-rid-zeroes.html)

Phil Davy

Pivot chart: get rid of zeroes?

Hi,

I have created a pivot chart using a pivot table.

However I want the zeroes to be NULLs so they are displayed on the graph.

Unfortunately I cannot see how to do this; could someone please help? I
have tried the Table Option checkboxes in the bottom right corner to no
avail.

Thanks

Phil Davy

Pivot chart: get rid of zeroes?

Sorry, that should read NOT displayed on graphs

"Phil Davy" wrote:

Hi,

I have created a pivot chart using a pivot table.

However I want the zeroes to be NULLs so they are displayed on the graph.

Unfortunately I cannot see how to do this; could someone please help? I
have tried the Table Option checkboxes in the bottom right corner to no
avail.

Thanks

All times are GMT +1. The time now is 03:37 AM.