+ Reply to Thread
Results 1 to 4 of 4

Setting a dynamic range for a chart

  1. #1
    Registered User
    Join Date
    08-27-2008
    Location
    RI
    Posts
    2

    Setting a dynamic range for a chart

    I have been stuck on this for a while....

    I need to create a dynamic range for my chart

    It should start at $M$3 and end at $T (the number that comes after "T" needs to be the number found in cell G4)

    so if G4=84

    the range would be $M$3:$T$84

    any help would be awesome

    Thanks,
    Dan!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482
    Rather than specifying the complete data set for the chart you need to create a named range for each series.

    Can you post example file with require chart based on static data?
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-27-2008
    Location
    RI
    Posts
    2
    Thanks for the quick help...I can't upload the file because of a firewall...

    How do i create a named range and what would the format for each of these named ranges be?

    Thanks so much,
    Dan

    (edit)
    (if you can not help without the file i compleatly understand)

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482
    Search the forum for Dynamic ranges, there are plenty of examples.

+ 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. dynamic named range relating to cell values
    By mark_jam3s in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2008, 06:57 AM
  2. Chart & Data Table Range displays
    By kostarica in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-12-2008, 08:05 PM
  3. VBA code for dynamic name range
    By weii in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2007, 07:36 PM
  4. Ignore Data for Dynamic Range
    By dborchardt in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-08-2006, 05:02 PM
  5. Dynamic Chart
    By Grek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-28-2006, 12:29 PM

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