+ Reply to Thread
Results 1 to 3 of 3

Dynamic upper and lower boundary

  1. #1
    Registered User
    Join Date
    11-21-2019
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2016
    Posts
    6

    Dynamic upper and lower boundary

    Hi everyone.

    I have a problem with my dynamic data sheet where I would like to add a upper and lower boundary. I have attached a xlsx file.

    The data for the data table will sometimes be updated by import (the function is not in this test sheet), so the table will be expand vertical over time.
    I would like to add an upper and lower boundary line (fx upper = 7 and lower =2) on the graph that automatically extending as more data are added. Therefore the drag option where data is copied down to the next cell is not an option.

    I would like the boundaries could be operated from one cell and not have to have columns for the upper and lower limit.

    The last goal is to be able to adjust the value of the boundaries (yellow cells) so the boundaries change on the graph.

    I hope someone can help me :-)
    Attached Files Attached Files
    Last edited by excelismylifetoo; 11-21-2019 at 05:22 AM.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: Dynamic upper and lower boundary

    created two names for dinamic ranges: for months and data
    and used those names as sources for grath
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-21-2019
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2016
    Posts
    6

    Re: Dynamic upper and lower boundary

    Thank you tim201110 for your reply :-) It was helping me a lot :-)

+ 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. Copy and insert row below within fixed upper limit and dynamic lower limit
    By droffel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2015, 08:57 PM
  2. upper and lower limit in charts made dynamic
    By rajasekar93 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-30-2015, 11:07 AM
  3. upper to lower case
    By stevekirk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-23-2008, 01:35 AM
  4. Upper and Lower Quartiles L@@K........
    By blade527 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 10-25-2006, 10:51 AM
  5. Lower Boundary of Vertical Scrollbar
    By noplasma in forum Excel General
    Replies: 0
    Last Post: 01-05-2006, 01:24 PM
  6. [SOLVED] Changing file in all upper case to upper and lower case
    By Sagit in forum Excel General
    Replies: 14
    Last Post: 08-25-2005, 10:05 PM
  7. [SOLVED] How do I convert all upper case excel sheet into upper and lower .
    By DebDay in forum Excel General
    Replies: 1
    Last Post: 03-09-2005, 05:06 PM

Tags for this Thread

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