Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Location
    CALIFORNIA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Graphing Zero Values (Excel 2003)

    Edited by HansV to present data in table

    Hello,

    I have a simple pie chart that I would like to omit the zero values from. Right now when I plot the chart it is a little busy because I have several categories that are empty right now. Here is the data I'm trying to graph:

    <table border=1><td>COL A</td><td>COL B</td><td>COL C</td><td>Name</td><td>Shares</td><td>Value</td><td>L 2040</td><td align=right>0</td><td align=right>$-</td><td>L 2030</td><td align=right>0</td><td align=right>$-</td><td>L 2020</td><td align=right>0</td><td align=right>$-</td><td>L 2010</td><td align=right>0</td><td align=right>$-</td><td>L Income</td><td align=right>0</td><td align=right>$-</td><td>G Fund</td><td align=right>195.1648</td><td align=right>$2,137.05</td><td>F Fund</td><td align=right>176.1569</td><td align=right>$1,861.98</td><td>C Fund</td><td align=right>568.4031</td><td align=right>$7,559.76</td><td>S Fund</td><td align=right>519.7468</td><td align=right>$8,284.76</td><td>I Fund</td><td align=right>140.4356</td><td align=right>$2,230.12</td></table>
    The following functions populates the graph: SERIES(,TSP!$A$17:$A$26,TSP!$C$17:$C$26,1)

    The first five rows currently try to populate the same pie wedge. I would like to just toss these out automatically.

    Any help would be appreciated.

    Respectfully,
    Shaun

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Graphing Zero Values (Excel 2003)


  3. #3
    New Lounger
    Join Date
    Jul 2002
    Location
    CALIFORNIA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graphing Zero Values (Excel 2003)

    Hans,

    Thanks...

    Regards,
    Shaun

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •