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!
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!
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".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks