+ Reply to Thread
Results 1 to 1 of 1

Pareto Pivot charting. How do I stop excel from plotting sums that are zero?

  1. #1
    Registered User
    Join Date
    10-07-2014
    Location
    GR
    MS-Off Ver
    2013
    Posts
    3

    Pareto Pivot charting. How do I stop excel from plotting sums that are zero?

    I am trying to figure out how to prevent Excel from Plotting data that has a sum of zero in a Pivot table. Please see attached.

    In the attached on the "PV Pareto of all defects" tab you will see that it plotted Criteria #'s 32,5,7,12,31,14,29,1,30,9,22,27,21,19,15,13. All have Zero value. How do I prevent Excel from showing these without having to remove and/or add manually every time I want to run my charting?

    Do not plot if value is =0 or blank.

    Thank you very much!
    Attached Files Attached Files

+ 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. Charting sums across dates, how to get sum of days only
    By Aceball in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-18-2006, 05:01 PM
  2. PLOTTING/CHARTING Help!
    By mcr1 in forum Excel General
    Replies: 1
    Last Post: 05-27-2006, 10:25 AM
  3. [SOLVED] How do you stop excel from charting empty cells/null values as zer
    By Abe-air in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-20-2006, 08:10 PM
  4. [SOLVED] charting biweekly headcount - chart is plotting everyday
    By Julie in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-22-2005, 01:05 PM
  5. Replies: 5
    Last Post: 04-21-2005, 04:06 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