Data Visualization Issue - Misaligned on X Axis

[jwb1012]

Hi All,

I attempted to post an attachment, but it appears I do not have this permission? I am attempting to fill the are under my XY scatter plot, but for some reason the area chart and XY scatter plot are just slightly misaligned along the X Axis. If anyone is willing to attempt to recreate this to help me troubleshoot, here is the initial guidance I am following:

https://peltiertech.com/fill-under-between-series-in-excel-chart/

		Area Chart
		X Value	Y Value
Scatter Plot	-1,000.00	0.00
X Value	Y Value	-914.29	0.00
-32,000,000.00	0.00	-914.29	0.00
-14,000,000.00	-1.00	-400.00	-1.00
-4,000,000.00	-2.00	-114.29	-2.00
-2,000,000.00	-3.00	-57.14	-3.00
0.00	-3.00	0.00	-3.00
0.00	-3.00	0.00	-3.00
2,000,000.00	-3.00	57.14	-3.00
4,000,000.00	-2.00	114.29	-2.00
14,000,000.00	-1.00	400.00	-1.00
32,000,000.00	0.00	914.29	0.00
		914.29	0.00
		1,000.00	0.00
-3.50	Y min
0.00	Y max

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[thisoldman]

Looks great!

Colors from ColorBrewer – http://colorbrewer2.org/

My workbook – https://www.dropbox.com/s/tmlkn25euy4s67n/funnel_chart.xlsx?dl=0

 

[jwb1012]

@thisoldman...any thoughts on quick way to reduce this to a 3 level funnel?

 

[thisoldman]

Book1
	I	J	K	L	M	N	O
5	Scatter Plot			Area Charts
6	x1	y1		x2	y2	y3	y4
7	-32 M	0		0	0	0	0
8	-32 M	-1		0	0	0	0
9	-4 M	-2.5		80	0	0	0
10	-1 M	-3.5		80	-1	-1	-1
11	0 M	-3.5		360	-2.5	-2.5	-1
12	1 M	-3.5		390	-3.5	-2.5	-1
13	4 M	-2.5		400	-3.5	-2.5	-1
14	32 M	-1		410	-3.5	-2.5	-1
15	32 M	0		440	-2.5	-2.5	-1
16				720	-1	-1	-1
17				720	0	0	0
18				800	0	0	0
19				800	0	0	0
20
21	-40 M	x min		0	x min
22	40 M	x max		800	x max
ThreeSections

Formula in L9 is copied down through L17: =(I7 + 40000000) / 100000

New tab added to the file on (in?) Dropbox: https://www.dropbox.com/s/tmlkn25euy4s67n/funnel_chart.xlsx?dl=0