Graphing the Spread Between Two Named Ranges

Nate123

New Member
Joined
Oct 8, 2010
Messages
8
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.
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Steve=True

Well-known Member
Joined
May 27, 2011
Messages
993
It can probably be done with another named formula that compares and subtracts the 2 formulas in an array fashion.

Probably try sumproduct()
 

Watch MrExcel Video

Forum statistics

Threads
1,123,385
Messages
5,601,331
Members
414,446
Latest member
CRAVIN

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top