+ Reply to Thread
Results 1 to 12 of 12

How to Remove 0 Values from Pie of Pie Chart

  1. 09-23-2017, 07:31 PM #1
    nevernine9
    nevernine9 is offline
    Registered User
    Join Date
    09-23-2017
    Location
    Toronto, ON
    MS-Off Ver
    Microsoft Office 365 Subscription MSO (Version 2310 Build 16.0.1
    Posts
    52

    How to Remove 0 Values from Pie of Pie Chart

    Hi,

    Here is Trying to make a pie of pie chart - Attachment 539525
    Please help me as I want remove 0 Category Name and Values "February,0" from first plot and "June,0" from second plot or either one.

    I Would be thankful if someone could help me out .

    Thanks a lot!
    Attached Files Attached Files
    Last edited by nevernine9; 09-23-2017 at 07:35 PM.
    Reply With QuoteRegister To Reply
  2. 09-23-2017, 08:31 PM #2
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to Remove 0 Values from Pie of Pie Chart

    like this?

    If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
    then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
    If you did it - ignore it.
    Thank you.
    Attached Files Attached Files
    Last edited by sandy666; 09-23-2017 at 08:48 PM.
    Reply With QuoteRegister To Reply
  3. 09-24-2017, 01:40 AM #3
    nevernine9
    nevernine9 is offline
    Registered User
    Join Date
    09-23-2017
    Location
    Toronto, ON
    MS-Off Ver
    Microsoft Office 365 Subscription MSO (Version 2310 Build 16.0.1
    Posts
    52

    Re: How to Remove 0 Values from Pie of Pie Chart

    Yes, Exactly like this,

    But without using "=NA()", still is it possible ?

    Thanks for your reply.
    Last edited by nevernine9; 09-24-2017 at 01:47 AM.
    Reply With QuoteRegister To Reply
  4. 09-24-2017, 02:00 AM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: How to Remove 0 Values from Pie of Pie Chart

    Charts dont plot (or "see") cells with errors in them, thats why sandy did it that way. if you change the error answer, the point will show
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  5. 09-24-2017, 02:04 AM #5
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to Remove 0 Values from Pie of Pie Chart

    If you don't like N/A you can use Conditional formatting to "hide" it

    hideNA.jpg
    Attached Files Attached Files
    Last edited by sandy666; 09-24-2017 at 02:07 AM.
    Reply With QuoteRegister To Reply
  6. 09-24-2017, 02:15 AM #6
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to Remove 0 Values from Pie of Pie Chart

    Thanks for rep

    but

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
  7. 09-25-2017, 01:58 PM #7
    nevernine9
    nevernine9 is offline
    Registered User
    Join Date
    09-23-2017
    Location
    Toronto, ON
    MS-Off Ver
    Microsoft Office 365 Subscription MSO (Version 2310 Build 16.0.1
    Posts
    52

    Re: How to Remove 0 Values from Pie of Pie Chart

    Hi, Sandy666
    I did try in my file, but not succeed.
    Here is my Original attachment.

    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 09-25-2017, 02:20 PM #8
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to Remove 0 Values from Pie of Pie Chart

    =SUMIF(P4:P8,"<>#N/A")

    =IF(SUM(D4:O4)=0,NA(),SUM(D4:O4))

    CF: =ISERROR(P3) + font format to apprpriate colour


    Is that what you want?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 09-25-2017, 02:25 PM #9
    nevernine9
    nevernine9 is offline
    Registered User
    Join Date
    09-23-2017
    Location
    Toronto, ON
    MS-Off Ver
    Microsoft Office 365 Subscription MSO (Version 2310 Build 16.0.1
    Posts
    52

    Re: How to Remove 0 Values from Pie of Pie Chart

    Thanks Sandy666, For your kind support.
    You are Star...


    I'm closing this thread.
    Reply With QuoteRegister To Reply
  10. 09-25-2017, 02:26 PM #10
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to Remove 0 Values from Pie of Pie Chart

    Don't close just set this thread to Solved
    Reply With QuoteRegister To Reply
  11. 09-25-2017, 02:28 PM #11
    nevernine9
    nevernine9 is offline
    Registered User
    Join Date
    09-23-2017
    Location
    Toronto, ON
    MS-Off Ver
    Microsoft Office 365 Subscription MSO (Version 2310 Build 16.0.1
    Posts
    52

    Re: How to Remove 0 Values from Pie of Pie Chart

    marked as "Solved"...
    Reply With QuoteRegister To Reply
  12. 09-25-2017, 02:33 PM #12
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to Remove 0 Values from Pie of Pie Chart

    Thanks for that
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to Remove X Axis Labels in a Waterfall Chart With Zero Values?
    By SH81 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-05-2015, 02:07 AM
  2. Remove gaps for missing values in column chart
    By Mthes in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-22-2014, 05:20 AM
  3. Pie Chart Help - I Want To Hide Values/Use Values But Not Show In Chart
    By RandomlySet in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-17-2013, 12:54 PM
  4. [SOLVED] 2010 - Remove zero vertical axis line in 3-D column chart with positive & negative values
    By callmetim in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-03-2013, 09:18 AM
  5. Macro to remove duplicates values and keep unique values bases on multiple criteria
    By Ricker090 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2011, 04:37 PM
  6. [SOLVED] zero value remove chart
    By Graeme in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-23-2005, 02:40 PM
  7. How to remove 1 bar from bar chart??Thank you!
    By crossingmind in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2005, 11: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1