Create rolling Charts

[mohan08]

am able to create rolling chart in excel on column value using offset function. but need to use rows for the same. Could you pls help on this

 

[mohan08]

Here attached the spread sheet for reference, Required help on charts for Sheet 2

 

[Hui]

Add 2 Named Formula

HValues: =OFFSET('Rolling Chart on Rows'!$A$2,0,COUNT('Rolling Chart on Rows'!$2:$2),1,-3)
HValueLabels: =OFFSET(HValues,-1,0)
Then add a chart as before

or see the attached file:

 

[mohan08]

Thanks Hui