+ Reply to Thread
Results 1 to 3 of 3

Show zeros in table, but not in chart

  1. #1
    Forum Contributor
    Join Date
    06-10-2005
    MS-Off Ver
    2007
    Posts
    223

    Show zeros in table, but not in chart

    Hi, I have a template that pulls data into a table with 20 sectors and I want to show all of them. I have a pie chart underneath which uses the table as the datasource, and I only want to display the sectors with values. Is there any way to easily suppress the zeros in the pie chart?
    Thanks,
    Phillycheese
    Last edited by Phillycheese5; 03-22-2012 at 03:25 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: Show zeros in table, but not in chart

    When I run a test of this, the zero category shows in the Legend but not the chart(pie area).

    This seems reasonable too. We want to know if a category is included in the charting or not. No space is wasted on a zero value.

  3. #3
    Forum Contributor
    Join Date
    06-10-2005
    MS-Off Ver
    2007
    Posts
    223

    Re: Show zeros in table, but not in chart

    Dennis....you're absolutely right. The zero values I was getting were the result of some bad data which had very small amounts (and showed as zero on the table). I will adjust my datasource accordingly. I appreciate you testing this.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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