+ Reply to Thread
Results 1 to 4 of 4

Pie Chart Remove zeros named range problem

  1. #1
    Forum Contributor
    Join Date
    09-25-2009
    Location
    Indiana
    MS-Off Ver
    Excel 2003
    Posts
    141

    Pie Chart Remove zeros named range problem

    I'm new to charting and named ranges, so I'm struggling with it and think there's probably an easy solution. I have attached the workbook with a pie chart that has some example labels and data. If the value of the data is zero, I don't want it included in the chart. I have named ranges that I'm having a problem referencing. I think it will work once I resolve that... There will be macros eventually, so it needs to stay an xlsm file (if that matters). Thanks for any help/suggestions.
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    2010
    Posts
    3,535

    Re: Pie Chart Remove zeros named range problem

    You were nearly there. Just missed two little actions.
    1) Your named ranges weren't referencing a sheet in your file. They were referencing a sheet name from the tutorial you were following.
    2) You hadn't changed the ranges the chart was using to use the named ranges, so they were still looking at E2:E25 & F2:F25.

    I've amended them in the attached and all should work now.

    BSB
    Attached Files Attached Files
    Please show appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Forum Contributor
    Join Date
    09-25-2009
    Location
    Indiana
    MS-Off Ver
    Excel 2003
    Posts
    141

    Re: Pie Chart Remove zeros named range problem

    Got it! Thanks for the explanation!!

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    2010
    Posts
    3,535

    Re: Pie Chart Remove zeros named range problem

    No problem. Happy to help

    BSB

+ 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