+ Reply to Thread
Results 1 to 2 of 2

Filter Unwanted Numbers From Chart

  1. #1
    Registered User
    Join Date
    11-22-2013
    Location
    USA
    MS-Off Ver
    2003, 2007, 2010, Office 365
    Posts
    31

    Filter Unwanted Numbers From Chart

    I need to filter unwanted numbers from a pivot chart. I am looking for the ability to filter out data points which occur certain number of times in the data table. My goal is compare "Part" reoccurrences (which is tallied by "Count of NMN") month over month, and my boss may want to see everything that reoccurred more than once or more than twice. Looking at the attached graph, the single occurrence items clutter my chart and serve no purpose as I am evaluating reoccurrences.

    Pre-filtering the data is not an option because future data may contain reoccurrences of the parts which now only have 1 instance.
    Attached Files Attached Files

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

    Re: Filter Unwanted Numbers From Chart

    Go to the Data sheet where you have the pivot table. Right click on any of the Part numbers. Select Filter -> Value Filters -> Count of NMN -> is greater than 1.
    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. [SOLVED] Macro/VBA code to Filter and delete unwanted data
    By robertguy in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-29-2018, 11:40 PM
  2. Macro to filter on unwanted data and delete
    By robertguy in forum Excel General
    Replies: 1
    Last Post: 12-07-2016, 02:31 PM
  3. [SOLVED] to block unwanted cells when i filter the data in A column
    By girishhb in forum Excel General
    Replies: 5
    Last Post: 03-07-2014, 07:47 AM
  4. [SOLVED] Auto filter and delete unwanted rows - Micro help
    By turbo600hp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-26-2012, 05:19 PM
  5. How to filter unwanted data
    By zldomi in forum Excel General
    Replies: 7
    Last Post: 05-14-2008, 11:29 AM
  6. Advanced filter- Specify unwanted record to show
    By leecs in forum Excel General
    Replies: 7
    Last Post: 10-08-2007, 06:40 AM
  7. Filter out unwanted data
    By bl81 in forum Excel General
    Replies: 1
    Last Post: 05-02-2007, 04:39 PM

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