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/



[TABLE="width: 356"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2, align: center"]Area Chart[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: center"]X Value[/TD]
[TD="align: center"]Y Value[/TD]
[/TR]
[TR]
[TD="colspan: 2, align: center"]Scatter Plot[/TD]
[TD="align: right"]-1,000.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="align: center"]X Value[/TD]
[TD="align: center"]Y Value[/TD]
[TD="align: right"]-914.29[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="align: right"]-32,000,000.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]-914.29[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="align: right"]-14,000,000.00[/TD]
[TD="align: right"]-1.00[/TD]
[TD="align: right"]-400.00[/TD]
[TD="align: right"]-1.00[/TD]
[/TR]
[TR]
[TD="align: right"]-4,000,000.00[/TD]
[TD="align: right"]-2.00[/TD]
[TD="align: right"]-114.29[/TD]
[TD="align: right"]-2.00[/TD]
[/TR]
[TR]
[TD="align: right"]-2,000,000.00[/TD]
[TD="align: right"]-3.00[/TD]
[TD="align: right"]-57.14[/TD]
[TD="align: right"]-3.00[/TD]
[/TR]
[TR]
[TD="align: right"]0.00[/TD]
[TD="align: right"]-3.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]-3.00[/TD]
[/TR]
[TR]
[TD="align: right"]0.00[/TD]
[TD="align: right"]-3.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]-3.00[/TD]
[/TR]
[TR]
[TD="align: right"]2,000,000.00[/TD]
[TD="align: right"]-3.00[/TD]
[TD="align: right"]57.14[/TD]
[TD="align: right"]-3.00[/TD]
[/TR]
[TR]
[TD="align: right"]4,000,000.00[/TD]
[TD="align: right"]-2.00[/TD]
[TD="align: right"]114.29[/TD]
[TD="align: right"]-2.00[/TD]
[/TR]
[TR]
[TD="align: right"]14,000,000.00[/TD]
[TD="align: right"]-1.00[/TD]
[TD="align: right"]400.00[/TD]
[TD="align: right"]-1.00[/TD]
[/TR]
[TR]
[TD="align: right"]32,000,000.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]914.29[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]914.29[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1,000.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]-3.50[/TD]
[TD]Y min[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]0.00[/TD]
[TD]Y max[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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