Color the area inbetween two lines in a chart/graph?

[Jyggalag]

Hi all,

I currently have this graph here:

I would like to color the area inbetween the yellow and the red line with an orange color. I would like to know:

1) is this possible, and if so, how?
2) if it is possible, is it also possible to make it do this coloring without pasting the orange color over the white line inbetween the graphs?

I would truly appreciate some assistance here, as I have basic to none experience in terms of excel graphs

Thank you all!

 

[Georgiboy]

I have done this before by adding two helper columns to the data and adding two more series in the graph.

Add a column to your data named: Base - Make this column be the lower values of the parallel line.
Add a column to your data named: Difference - Make this column be the difference between the upper and lower values of the parallel line.
Right click o your graph and select: Select data
Click on the: 'Add' button to add a series
Add the: 'Base' column to the 'Legend Entries'
Click on the: 'Add' button to add a series
Add the: 'Difference' column to the 'Legend Entries'
Click: OK
Right click one of the lines on the graph and select: Change Series Chart Type
Set: 'Base' to be a stacked area
Set: 'Difference' to be a stacked area
Click: OK
Now right click on the area under the lower line and set 'Fill' to 'none'
You can delete the 'Base' and 'Difference' from the legend on the graph if you wish

Main Head	Main Val	Lower Val	Upper Val	Base	Difference
1	90	78	98	78	20
2	92	82	102	82	20
3	88	76	96	76	20
4	87	74	94	74	20
5	81	73	93	73	20
6	83	70	90	70	20
7	70	65	85	65	20
8	79	70	90	70	20
9	85	74	94	74	20
10	80	78	98	78	20

 

[Georgiboy]

Creates this

 

[Jyggalag]

I have done this before by adding two helper columns to the data and adding two more series in the graph.

Add a column to your data named: Base - Make this column be the lower values of the parallel line.
Add a column to your data named: Difference - Make this column be the difference between the upper and lower values of the parallel line.
Right click o your graph and select: Select data
Click on the: 'Add' button to add a series
Add the: 'Base' column to the 'Legend Entries'
Click on the: 'Add' button to add a series
Add the: 'Difference' column to the 'Legend Entries'
Click: OK
Right click one of the lines on the graph and select: Change Series Chart Type
Set: 'Base' to be a stacked area
Set: 'Difference' to be a stacked area
Click: OK
Now right click on the area under the lower line and set 'Fill' to 'none'
You can delete the 'Base' and 'Difference' from the legend on the graph if you wish

Main Head	Main Val	Lower Val	Upper Val	Base	Difference
1	90	78	98	78	20
2	92	82	102	82	20
3	88	76	96	76	20
4	87	74	94	74	20
5	81	73	93	73	20
6	83	70	90	70	20
7	70	65	85	65	20
8	79	70	90	70	20
9	85	74	94	74	20
10	80	78	98	78	20

This works. Absolutely amazing, thank you so much Sir.!