Expand Defined Name Range Horizontally to Dynamically Change Chart with new data

Hello Everyone,

I am working on streamlining a report. With each succeeding new month, new data is placed into my workbook horizontally, according to month. The data is ten used to populate a bar chart comparing the current year and SPLY performance for each month. The data is currently organized as such:
BI BJ BK BL BM BN BO BP BQ BR BS BT BU BV
28 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
29 Revenue FY18 5,575,407 #N/A
30 SPLY 6,926,773 #N/A



From January moving forward, I've written an IF formula to display "#N/A" as those months have not occurred yet. My goal is to extend a named range horizontally with each succeeding month so I do not have to change the cell references of my chart each reporting month. Any assistance is greatly appreciated.

Respectfully,

Michael