I'm afraid I get the same result as before, even using the suggested formula of =OFFSET(INDIRECT("Sheet1!"&ADDRESS(Sheet1!$J$2,3)),0,0,Sheet1!$...
I'm trying to define a range for the x-axis by using =OFFSET([starting cell],0,0,$K$2,1). The challenge is finding a formula that (in this case) reso...
Please see attached file. The original data is in columns A, C and D. What I'm trying to do is create up to 7 charts to plot the daily cumulative ...
Hi Sunny - your reply does indeed solve my problem. Thanks very much for your help! Regards, Bob
I tried using a Table, but each month's data has to overwrite the prior month, which the table wouldn't let me do. I then tried using an Offset funct...
Mynda - Thanks for the diagnosis; I now see my problem. However, trying to fix it raised two other points. 1. I wasn't familiar with "diagram vie...
I've attached a small, sanitized file that exhibits the problem I'm facing. Thanks for your help!