Hi,
This seems like it will be straightforward but i can't get it to work. I've created some names that i'm trying to use for dynamic charts. The first one i created worked fine in the chart but the second won't work. i can't seem to change the series in the second graph to read off the new name. 'Dates' gives me the date range along the x-axis while 'PurchaserValuers' gives me the first set of data i want. The second set of data i want is 'Repurchase' and is shown below.The names are below:
Dates =OFFSET(Sheet2!$D$2,0,0,1, COUNTIF(Sheet2!$D$2:$W$2, ">0"))
PurchaserValues =OFFSET(Dates,1,0)
Repurchase =OFFSET(Dates,3,0)
All i want is another chart for repurchase but it won't let me change the series. Ultimately there will be more data with more graphs so i need to get multiple graphs working. Attached is a snapshot of the file i'm using with the above formulas.
Thanks,
John
Bookmarks