Share via

Hide zero and blank data in pivot table display

Anonymous
2022-09-20T14:43:37+00:00

Hello,

I have a pivot table and graph with fields applied along with filters. When i select my filters i see blank spaces on my graph when a given category is zero. How can automatically hide all zero and blank data when i select my filters?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

9 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-09-20T17:49:36+00:00

    I know i can right click on one of the antibiotics and hide manually, but i rather not do this every time i select a different filter.

    0 comments
  2. Ashish Mathur 101K Reputation points Volunteer Moderator
    2022-09-20T23:21:56+00:00

    Hi,

    Share the download link of your MS Excel file. If data is confidential, please anonymise the data in the file. Ensure that your Pivot Table is already created in another tab of that file.

    0 comments
  3. Anonymous
    2022-09-21T13:20:40+00:00

    How do i attach a file? Can i send it to you directly?

    0 comments
  4. Ashish Mathur 101K Reputation points Volunteer Moderator
    2022-09-21T23:18:30+00:00

    Upload the file to Google Drive/One Drive and share the download link.

    0 comments