ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   suppress zeros in a pivot chart (https://www.excelbanter.com/excel-discussion-misc-queries/150685-suppress-zeros-pivot-chart.html)

klp

suppress zeros in a pivot chart
 
Is there anyway to suppress the zeros in a pivot chart? My pivot table shows
activities for many different queues, and sometimes a particular queue won't
have a value for an activity that another queue has. When i chart just this
queue, the activity shows up as 0%. I don't want to delete the label, because
then when i change to another queue that DID have that activity, the value
won't show up.

Any thoughts?
thanks!
~klp


All times are GMT +1. The time now is 07:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com