+ Reply to Thread
Results 1 to 6 of 6

Easy way to hide lines with a chart until they are completed

  1. #1
    Registered User
    Join Date
    04-18-2018
    Location
    Brighton
    MS-Off Ver
    14.0.6129.5000
    Posts
    5

    Easy way to hide lines with a chart until they are completed

    Hi all,

    I have set up a table with formulas and produced extra line needing people to complete less information each time. I have also set up a number of charts which I'd like to set up initially so they are completed with further information as and when it is added. However I would like these non completed lines ommitted until they are completed.

    Is there any way though that you can easily hide all information that hasn't been added, so i.e.
    EACU April 9'18 - April 15'18
    EACU April 16'18 - April 22'18
    EACU April 23'18 - April 29'18........ etc.

    Otherwise the chart looks as though the value was 0 for these new months.

    I have tried using hide, but it only allows you to hide blank cells and this doesn't work as there is something within column (A) and J has #DIV/0.

    Any help/advice would be greatly appreciated.

    Many thanks
    Attached Images Attached Images

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    15,693

    Re: Easy way to hide lines with a chart until they are completed

    You could apply autofilter to the Attenddes column and select non-blank.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    04-18-2018
    Location
    Brighton
    MS-Off Ver
    14.0.6129.5000
    Posts
    5

    Re: Easy way to hide lines with a chart until they are completed

    Ah, so easy, thank you.

    Would you any idea, how you can set up a way of autofilling a line with information once data has been put into the next line. So for instance if someone were to add a new date into the first column and then it autofills with the formulas within that line?

    Would it via a macro?

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    15,693

    Re: Easy way to hide lines with a chart until they are completed

    You could convert the data to a Table, and then formulae will autofill.

    Hope this helps.

    Pete

  5. #5
    Registered User
    Join Date
    04-18-2018
    Location
    Brighton
    MS-Off Ver
    14.0.6129.5000
    Posts
    5

    Re: Easy way to hide lines with a chart until they are completed

    Hmm I'm not sure I understand.

    So I've seen it before where you start typing in the row underneath your last entry and it autofills, but I'm unsure whether I've seen formulas automatically get added and change to represent the new row.

    Thank you again
    Attached Images Attached Images

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5,608

    Re: Easy way to hide lines with a chart until they are completed

    I believe that what Pete is suggesting is that you choose a cell within your current data, say A10, and press the Ctrl + t keys. You should get a prompt stating that the current range is A2:P36 and has column headers. If you then select cell P36 and press the tab key a new row (37) will be added to the table. If you select M37 the formula =K37/H37 should be in that cell.
    In the attached example notice that if you select cell C3 and press the tab key then a formula corresponding to the one in C3 fills C4.
    If this doesn't clear things up it might be helpful to upload the sample worksheet from which the screenshots were made by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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