+ Reply to Thread
Results 1 to 2 of 2

Pivot Table/Chart and Slicers with Blanks (Hide Items with no data is checked)

  1. #1
    Registered User
    Join Date
    11-17-2020
    Location
    UK
    MS-Off Ver
    2016
    Posts
    21

    Pivot Table/Chart and Slicers with Blanks (Hide Items with no data is checked)

    Hello all!

    Every week, I have to update this excel, which has three sheets: one with the database (in which the range varies every week, it's never the same number of rows), a sheet with a pivot table with one calcuand a sheet with the pivot chart and respective slicers. The only the sheet will be available to the user will be the sheet "Analysis".

    So, as the number of rows of every week is difference, the datasource/the range of the pivot table is AA:EE, so I would only need to refresh the pivot table every week.

    The problem is that in the pivot chart and in the slicers, the option "Blank" appears, even though the option "Hide Items with no data is checked".

    Can you help me?

    Thank you!
    Attached Files Attached Files
    Last edited by caet_; 01-24-2022 at 12:22 PM.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,946

    Re: Pivot Table/Chart and Slicers with Blanks (Hide Items with no data is checked)

    Consider converting your source data to an Excel Table. One of the advantages of an Excel table is that they know how big they are so you will ALWAYS reference the exact amount of rows you have.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 07-14-2021, 11:03 AM
  2. Replies: 1
    Last Post: 12-22-2020, 04:52 AM
  3. Pivot table/chart with slicers help
    By m1ke86 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-01-2019, 02:51 PM
  4. Exclude items from chart slicers (even if they have data)
    By chicagolarsons in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-01-2019, 01:24 PM
  5. Dynamic Pivot Table and Chart Cell References with slicers - HELP
    By wespomeroy in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 02-22-2018, 03:26 PM
  6. [SOLVED] Excel Line Chart: Ignore blanks in data and in pivot table
    By TMMc in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-07-2017, 03:07 PM
  7. Replies: 2
    Last Post: 05-24-2013, 03:58 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1