excel - Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted) -

i'm trying create chart range built dynamically using indirect function. excel recognize range creating using indirect highlights corresponding range on sheet:

however when saving chart, error message saying function not valid:

does know problem / how create dynamic chart range specific start specific end point?

ps: you can download above spreadsheet here. formula using:
=indirect("sheet!"&e2&":"&e3)

mine similar sean's excellent answer, allows start , end day. first create 2 named ranges use index/match formulas pick begin , end days based on e2 , e3:

rngday

=index(sheet1!$a:$a,match(sheet1!$e$2,sheet1!$a:$a,0)):index(sheet1!$a:$a,match(sheet1!$e$3,sheet1!$a:$a,0)) 

rngvalue

=index(sheet1!$b:$b,match(sheet1!$e$2,sheet1!$a:$a,0)):index(sheet1!$b:$b,match(sheet1!$e$3,sheet1!$a:$a,0)) 

you can click series in chart , modify formula to:

=series(sheet1!$b$1,sheet1!rngday,sheet1!rngvalue,1) 

here's nice chandoo post on how use dynamic ranges in charts.