+ 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
    152

    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, UK
    MS-Off Ver
    365
    Posts
    7,468

    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

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

    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, UK
    MS-Off Ver
    365
    Posts
    7,468

    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)

Similar Threads

  1. [SOLVED] Remove zeros from chart
    By great_AS in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-09-2016, 12:31 PM
  2. Replies: 0
    Last Post: 03-08-2016, 02:25 PM
  3. Dynamic Named Range Picking up Cells with Zeros (0s)
    By bjnockle in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-06-2014, 01:59 PM
  4. [SOLVED] VBA - Remove text from named range and table
    By ormerods in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 12-19-2013, 09:18 AM
  5. [SOLVED] How to remove a deleted named range completely
    By megaiooo in forum Excel General
    Replies: 8
    Last Post: 08-16-2013, 09:01 PM
  6. Remove prepositions in text using named range list
    By Northstjarna in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-10-2013, 09:09 AM
  7. Copy sheets and remove named range
    By digdug in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-08-2007, 04:41 AM

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