I hope you can help me please?

As a company we have totally re-gigged our product hierarchy.

We have a Sales & Operations Planning sheet used each month to plan the forecast, which is really important.

I've gone through the sheet and renamed/re-directed what I can, but now I'm abit stuck.

For each product group, it has its own sheet which shows 36 months (history sales/actuals), 18 months forecast sales, aswell as a MAT line, a last 3 month line and a trend line.

Which I am trying to recreate for the new sheets, I've done the forecast, actuals and trend, but I'm stuck with MAT & Last 3 months, but formula's on the existing graph formula's point towards named ranges within the whole sheet. I can copy/recreate the formula's, but I want to understand whats happening so I can confidently replicate it for the other 10 new sheets.

The exisiting formula's are:

=SERIES("MAT",,'SOP P7 2015 (June) Hierarchy change Clair backup 18 june.xlsm'!BE0MAT,5)

SOP P7 2015 .... is the name of my spreadsheet, so I type this in, but it will change each month as I rename it, and the title I have changed to reflect that it is a sheet in progress

BE0MAT is a named range

I'm not sure what the ,5 is for.

the 3 month existing formula is: =SERIES("Last 3 months",,'SOP P7 2015 (June) Hierarchy change Clair backup 18 june.xlsm'!BE0L3,6)

I have copied these out of the previous product group, which has a graph.

I hope that makes sense to you Excel-Guru's coz I'm stuck

Its taken me all afternoon to do the 3 formula's.

Thank
you x 1000,000,000
Clair