+ Reply to Thread
Results 1 to 3 of 3

Pivot Chart not to show $0

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    60

    Pivot Chart not to show $0

    Hi
    I have pivot table/chart.

    In the pivot chart is show all the $0 and make the chart bar very thin.

    Can I not show the $0 and make the bar thicker?

    In a, pivot chart, it show the date from 10Sep to 18Sep. We do not payment to this supplier and i do not want to should in the chart.

    Same as the other supplier, I only want to show when I have payment.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by bt123123; 09-04-2018 at 11:44 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    693

    Re: Pivot Chart not to show $0

    Assume you have below table and wants to creat a chart for the same.

    Region Sales

    North $100.00
    South $-
    East $120.00
    West $80.00

    Here, the Sales in South is zero and you want to hide it on chart.
    In order to do that, please right click on the chart > Select Data > Uncheck the 'South' in Axis label field

    In order to adjust the data series (i.e. reduce the gap of columns/bars), click on column or bar on the chart > Format Data Series > Reduce the gap width by adjusting the scroll bar backwards

    Q. How to upload attachments in Excel Forum?
    A. Go to advanced reply > Manage Attachments > Upload file > Close window
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-04-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    60

    Re: Pivot Chart not to show $0

    Quote Originally Posted by Shareez Saleem View Post
    Assume you have below table and wants to creat a chart for the same.

    Region Sales

    North $100.00
    South $-
    East $120.00
    West $80.00

    Here, the Sales in South is zero and you want to hide it on chart.
    In order to do that, please right click on the chart > Select Data > Uncheck the 'South' in Axis label field

    In order to adjust the data series (i.e. reduce the gap of columns/bars), click on column or bar on the chart > Format Data Series > Reduce the gap width by adjusting the scroll bar backwards

    Q. How to upload attachments in Excel Forum?
    A. Go to advanced reply > Manage Attachments > Upload file > Close window
    thanks
    I upload the data.

+ 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. Make Pivot Chart Only Show Top Information
    By kaleonard08 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-26-2016, 06:08 AM
  2. Show in a pivot chart only some sub-percentages from pivot table
    By kikonas in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-25-2016, 02:35 PM
  3. Pivot Chart needs to show different colors for different labels
    By johnsmit45 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-05-2016, 01:55 PM
  4. How NOT to show 0% values in Pivot chart?
    By Mirisage in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-20-2015, 04:48 PM
  5. Pivot chart - show only top 80%
    By c_morgan in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-14-2013, 04:49 PM
  6. [SOLVED] Multiple Columns in Pivot Table (but don't show in Pivot Chart)
    By Gideon1973 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-23-2012, 10:57 AM
  7. [SOLVED] Show stdev errorbars on pivot bar chart
    By Pieter in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-05-2006, 01:00 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