+ Reply to Thread
Results 1 to 2 of 2

"Dynamic" Line Chart

  1. #1
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    Microsoft 365
    Posts
    810

    "Dynamic" Line Chart

    Hi,

    I would like to create a line chart that is drawn automatically between start and end dates entered in cells A1 and B1, respectively.

    Can someone please suggest how I can create such a "dynamic" chart?

    Thanks!

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,444
    You need to define two dynamic ranges, one for the dates and one for the data
    Presuming Your dates start at F1 and your data starts at G1, go to

    Insert > Name > Define

    OFFSET($F$1,MATCH($A$1,$F$1:$F$19,0)-1,0,MATCH($B$1,$F$1:$F$19)-MATCH($A$1,$F$1:$F$19,0)+1,1)

    assign a name such as graphdates

    then

    =OFFSET(graphdates,0,1)

    assigned a name such as graphdata


    Then create the graph, and use these two names ranges as the dataset.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

+ 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