Excel offset function for multiple columns

Question

I want to use excel offset function to build a dynamic chart. Basically, I want my line chart always show the data for last 5 days. I know how to do it for a single variable, but for multiple variables, I have no idea. Can you help me？

My data is in below format. enter image description here

In the chart, there should be four dynamic lines--area1 vol, are2 vol, area3 vol, and the total vol.

Thank you.

Please provide the expected output for the sample data. Better in a table form than a graph. — trincot
– trincot, Commented Apr 13, 2017 at 22:56
You may be able to use Aggregate instead. Where is the source data? — Jacob Edmond
– Jacob Edmond, Commented Apr 13, 2017 at 23:12

user4039065 · Accepted Answer · 2017-04-13 23:20:56Z

2

Assuming Date is in A1 then,

=index(A:I, match(today()-4, A:A, 0), 0):index(A:I, match(today(), A:A, 0), 0)

Avoid the volatile OFFSET whenever possible; it usually can be done.

answered Apr 13, 2017 at 23:20

user4039065

Sign up to request clarification or add additional context in comments.

1 Comment

Amy Over a year ago

seemly, you have selected all the range, not just the colume B, D, F, and G. I can not put the rang into the chart using "select data".

Collectives™ on Stack Overflow

Excel offset function for multiple columns

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related