Results 1 to 11 of 11

Creating a Dynamic Graph Using Text Cell References

Threaded View

  1. #1
    Registered User
    Join Date
    03-28-2013
    Location
    Calgary
    MS-Off Ver
    Excel 2007
    Posts
    8

    Creating a Dynamic Graph Using Text Cell References

    Good morning,

    I am looking to create a graph based on a range between two cells.

    The user defines the row of these cells, and then indicates the desired start and end range (ie. start column and end column) in a specific area.

    Using this information, I have produced using the ADDRESS function two text cell references, which are located on sheet "References".

    Results:

    'Suburban (By District)'!$K$2 (Located in K4)
    'Suburban (By District)'!$U$2 (Located in L4)

    The sheet, row, and column are variable and determined by the user, so these locations will change depending on the user input. I want the graph to actively reflect these changes.

    In any case, my assumption was that I could make the range = 'References'!$K$4:'References'!$L$4'. This does not work. I imagine I should use the INDIRECT function, but that returns the values of the aforementioned locations, not the locations themselves.

    How do I create this range based on the text in K4 and L4?

    Thanks for any help.

    Regards,

    DJW
    Last edited by derekjwilson; 04-01-2013 at 10:58 AM.

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