Scrolling Chart replace full year format with month/year

[legend X]

Hi,

Need some help in replacing year format with month/year format in highlighted cells. Would prefer to show the value and format in cell B1 thru N1 for cell B2 thru N2 and B25 thru E25 (scroll bar). Using index formula in B25 and adding 1 to get value for C25 works well with existing setup but I would like to show trend in month-year format (e.g Jun-16, May-16 etc). See attachment.

Thank you.

 

[Hui]

I would change:
B25: =INDEX($B$1:$N$1,,$B$6+COLUMNS($B25:B25))
B26: =INDEX($B$3:$N$3,,$B$6+COLUMNS($B26:B26))
Copy both across

 

[legend X]

Hui, thank you so much!