+ Reply to Thread
Results 1 to 1 of 1

Hide legend items in a LINE graph when associated value = zero or blank

  1. #1
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    268

    Hide legend items in a LINE graph when associated value = zero or blank

    I have been searching this site for an answer to my problem but found one solution for a pie graph. I am looking for a similar solution for a LINE graph. Attached is what I found. It works beautifully but the formulas are not for a row of values. I am referring ONLY to the formulas which are used in the Name Manager. In step 4 of one of the attachments, is where my problem lies. I hope you guys will be able to follow this and really try to help me. Thanx a lot..
    Attached Files Attached Files

+ 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] Hide legend items in a graph when associated value = zero or blank
    By bdicarlo1 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-07-2018, 06:44 AM
  2. [SOLVED] Line Graph - Legend Series on an Axis - League Table Tracker
    By JungleJme in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-14-2012, 11:00 AM
  3. Line graph with coloured points corresponding to legend
    By laurasmith2121 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-26-2011, 03:30 AM
  4. [SOLVED] Can I remove just one title within a graph legend and not hide th.
    By KLF in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-07-2005, 03:05 PM
  5. Chart Legend Items: hide/show
    By Richard Ahlvin in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 09-05-2005, 11:05 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