+ Reply to Thread
Results 1 to 2 of 2

display only lines present

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    display only lines present

    Hi everyone.
    Is it possible to display only the 2 lines in the graph?
    Now there are 2 rows for the data and 3 empty rows.
    Only 2 series of columns must be present in the graph.
    I hope to be explained to me.
    max
    Attached Files Attached Files
    Last edited by max_max; 07-14-2020 at 04:17 PM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,619

    Re: display only lines present

    Hi,
    I'm not sure if it worked the same way in Excel 2007 (I do not have it installed any longer) but with version 2016 it is enough to use the autofilter on the data and not visible data is not used at the graph.

    See attached.

    Another possibility is to use the name manager to create "Dynamic graph" - see for example https://peltiertech.com/Excel/Charts...umnChart1.html
    Attached Files Attached Files
    Best Regards,

    Kaper

+ 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] Display the corresponding names of the most present student in a class
    By Aristotle Exclaims in forum Excel General
    Replies: 18
    Last Post: 08-29-2017, 02:10 PM
  2. Display account numbers where stock items are not present.
    By guerillaexcel in forum Excel General
    Replies: 4
    Last Post: 09-05-2013, 04:40 AM
  3. Replies: 2
    Last Post: 06-19-2012, 07:48 AM
  4. Portable projector that can display / present Excel?
    By worriedwart in forum Excel General
    Replies: 3
    Last Post: 11-06-2009, 06:43 PM
  5. Formula to display whether a text data is present or not in a column
    By shuresh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-11-2009, 03:42 AM
  6. Replies: 3
    Last Post: 02-26-2009, 04:28 PM
  7. display intersection value for 2 lines
    By gab2409 in forum Excel General
    Replies: 3
    Last Post: 02-28-2005, 12:29 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