Shade the area between multiple lines (3+) with Excel charts

[doobage]

I've figured out how to shade the area between two lines in an Excel Chart. Now I need some help figuring out how to do the same thing but for at least three lines.

Here is a sample data set that I'm trying to chart and shade.

Top Median Bottom
7.4% 3.4% -5.7%
7.5% 3.4% -4.0%
3.6% -0.5% -8.5%
8.8% 4.2% -2.1%

I'd like for there to be shading between the "Median" & "Bottom" lines AND the "Top" & "Median" lines. Does anyone have a spreadsheet template that they can share? Thanks in advance for the help.

 

[RickXL]

Hi,

I think you may be able to adapt an Area Chart to do this. If you need the original lines adding then you can use a Combo chart.

To make an Area Chart work you need to massage the data.

Excel 2013
	A	B	C	D	E	F	G
1	Bottom	Median	Top		Bottom	Median	Top
2	-5.70%	3.40%	7.40%		-5.70%	9.10%	4.00%
3	-4.00%	3.40%	7.50%		-4.00%	7.40%	4.10%
4	-8.50%	-0.50%	3.60%		-8.50%	8.00%	4.10%
5	-2.10%	4.20%	8.80%		-2.10%	6.30%	4.60%
Sheet1

Cell Formulas
Range	Formula
E2	=A2
F2	=B2-A2
G2	=C2-B2

 

[doobage]

RickXL,

Thanks for the quick help. Your massaging worked. To clarify should anyone else be dealing with a similar issue, I created an Area Chart with the entire data set A1:G5 and then converted Areas A, B, and C to a Marked Line chart. Then you can play with the Fill of Areas E, F, and G to better highlight the shading between the lines.

Thank you again!

Hi,

I think you may be able to adapt an Area Chart to do this. If you need the original lines adding then you can use a Combo chart.

To make an Area Chart work you need to massage the data.

Excel 2013
	A	B	C	D	E	F	G
1	Bottom	Median	Top		Bottom	Median	Top
2	-5.70%	3.40%	7.40%		-5.70%	9.10%	4.00%
3	-4.00%	3.40%	7.50%		-4.00%	7.40%	4.10%
4	-8.50%	-0.50%	3.60%		-8.50%	8.00%	4.10%
5	-2.10%	4.20%	8.80%		-2.10%	6.30%	4.60%
Sheet1

Cell Formulas
Range	Formula
E2	=A2
F2	=B2-A2
G2	=C2-B2

 

[RickXL]

No problem.

I am pleased you managed to get it working.

Regards,

 

[mupahjohn]

I am having a similar problem. I want to shade in between three lines what should i do

 

[mupahjohn]

Can I share my spread sheet