Graphing the Spread Between Two Named Ranges

[Nate123]

I have a dynamic line graph that pulls two series of data from named ranges based on inputs above the chart. It works fine for showing the values themselves in a line graph. However, now I would like to show the 'spread' between the two series. I.E. one series minus the other series for each point along the x-axis represented as one single line. Is this possible using just the named ranges, without having to calculate the spreads for all my different columns of data on the data sheet itself? Thanks for the help.

 

[Steve=True]

It can probably be done with another named formula that compares and subtracts the 2 formulas in an array fashion.

Probably try sumproduct()