Data Visualization Issue - Misaligned on X Axis

J

jwb1012

Board Regular
Joined
Oct 17, 2016
Messages
167
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]
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Sort by date Sort by votes
No one has permission to post attachments, the board has finite capacity which is better used hosting questions and links and the odd html graphic image
 
Upvote 0
I hope this will help you.

Area charts are a form of category charts. When you change the horizontal axis to a Date, Excel is going to place it where it wants. There are no negative Dates in Excel.

Rather than dividing up the area chart into 1,000 horizontal units, I used 800 units—an 800 unit scale fits your posted data so well. I used Custom number formatting for the labels: 0,," M"

For a filled funnel interior:

<tbody>
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67, width: 64"]Area[/TD]

[TD="class: xl66"]Scatter[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]0[/TD]
[TD="class: xl66, align: right"]0[/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67"]Y[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]0[/TD]
[TD="class: xl66, align: right"]0[/TD]

[TD="class: xl68, align: right"]-32 M[/TD]
[TD="class: xl66, align: right"]0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]80[/TD]
[TD="class: xl66, align: right"]0[/TD]

[TD="class: xl68, align: right"]-14 M[/TD]
[TD="class: xl66, align: right"]-1[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]260[/TD]
[TD="class: xl66, align: right"]-1[/TD]

[TD="class: xl68, align: right"]-4 M[/TD]
[TD="class: xl66, align: right"]-2[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]360[/TD]
[TD="class: xl66, align: right"]-2[/TD]

[TD="class: xl68, align: right"]-2 M[/TD]
[TD="class: xl66, align: right"]-3[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]380[/TD]
[TD="class: xl66, align: right"]-3[/TD]

[TD="class: xl68, align: right"]0 M[/TD]
[TD="class: xl66, align: right"]-3[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]400[/TD]
[TD="class: xl66, align: right"]-3[/TD]

[TD="class: xl68, align: right"]0 M[/TD]
[TD="class: xl66, align: right"]-3[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]400[/TD]
[TD="class: xl66, align: right"]-3[/TD]

[TD="class: xl68, align: right"]2 M[/TD]
[TD="class: xl66, align: right"]-3[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]420[/TD]
[TD="class: xl66, align: right"]-3[/TD]

[TD="class: xl68, align: right"]4 M[/TD]
[TD="class: xl66, align: right"]-2[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]440[/TD]
[TD="class: xl66, align: right"]-2[/TD]

[TD="class: xl68, align: right"]14 M[/TD]
[TD="class: xl66, align: right"]-1[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]540[/TD]
[TD="class: xl66, align: right"]-1[/TD]

[TD="class: xl68, align: right"]32 M[/TD]
[TD="class: xl66, align: right"]0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]720[/TD]
[TD="class: xl66, align: right"]0[/TD]

[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]800[/TD]
[TD="class: xl66, align: right"]0[/TD]

[TD="class: xl66, align: right"]0[/TD]
[TD="class: xl67"]x min[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]800[/TD]
[TD="class: xl66, align: right"]0[/TD]

[TD="class: xl66, align: right"]800[/TD]
[TD="class: xl67"]x max[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]

</tbody>

WWvRPku.png



For a filled funnel exterior, I switched the y values to positive numbers and formatted the secondary vertical axis to have "Values in reverse order.:


<tbody>
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, width: 73"][/TD]
[TD="class: xl67, width: 64"]Area[/TD]

[TD="class: xl66"]Scatter[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]0[/TD]
[TD="class: xl66, align: right"]0[/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67"]Y[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]0[/TD]
[TD="class: xl66, align: right"]0[/TD]

[TD="class: xl68, align: right"]-32 M[/TD]
[TD="class: xl66, align: right"]0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]80[/TD]
[TD="class: xl66, align: right"]0[/TD]

[TD="class: xl68, align: right"]-14 M[/TD]
[TD="class: xl66, align: right"]-1[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]260[/TD]
[TD="class: xl66, align: right"]1[/TD]

[TD="class: xl68, align: right"]-4 M[/TD]
[TD="class: xl66, align: right"]-2[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]360[/TD]
[TD="class: xl66, align: right"]2[/TD]

[TD="class: xl68, align: right"]-2 M[/TD]
[TD="class: xl66, align: right"]-3[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]380[/TD]
[TD="class: xl66, align: right"]3[/TD]

[TD="class: xl68, align: right"]0 M[/TD]
[TD="class: xl66, align: right"]-3[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]400[/TD]
[TD="class: xl66, align: right"]3[/TD]

[TD="class: xl68, align: right"]0 M[/TD]
[TD="class: xl66, align: right"]-3[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]400[/TD]
[TD="class: xl66, align: right"]3[/TD]

[TD="class: xl68, align: right"]2 M[/TD]
[TD="class: xl66, align: right"]-3[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]420[/TD]
[TD="class: xl66, align: right"]3[/TD]

[TD="class: xl68, align: right"]4 M[/TD]
[TD="class: xl66, align: right"]-2[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]440[/TD]
[TD="class: xl66, align: right"]2[/TD]

[TD="class: xl68, align: right"]14 M[/TD]
[TD="class: xl66, align: right"]-1[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]540[/TD]
[TD="class: xl66, align: right"]1[/TD]

[TD="class: xl68, align: right"]32 M[/TD]
[TD="class: xl66, align: right"]0[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]720[/TD]
[TD="class: xl66, align: right"]0[/TD]

[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]800[/TD]
[TD="class: xl66, align: right"]0[/TD]

[TD="class: xl66, align: right"]0[/TD]
[TD="class: xl67"]x min[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]800[/TD]
[TD="class: xl66, align: right"]0[/TD]

[TD="class: xl66, align: right"]800[/TD]
[TD="class: xl67"]x max[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]

</tbody>

h8TxDM4.png
 
Upvote 0
Thank you! I really appreciate the guidance and knowledge. Any thoughts on how to maintain alignment when the key inputs change? Did you use a formula for the X axis of the area chart?

[TABLE="width: 505"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Area Chart[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]X Value[/TD]
[TD]Y Value[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]Scatter Plot[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]X Value[/TD]
[TD]Y Value[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]-33,333,000.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]80.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]-13,000,000.00[/TD]
[TD="align: right"]-1.00[/TD]
[TD="align: right"]260.00[/TD]
[TD="align: right"]-1.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]-2,800,000.00[/TD]
[TD="align: right"]-2.00[/TD]
[TD="align: right"]360.00[/TD]
[TD="align: right"]-2.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]-800,000.00[/TD]
[TD="align: right"]-3.00[/TD]
[TD="align: right"]380.00[/TD]
[TD="align: right"]-3.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]-3.00[/TD]
[TD="align: right"]400.00[/TD]
[TD="align: right"]-3.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]-3.00[/TD]
[TD="align: right"]400.00[/TD]
[TD="align: right"]-3.00[/TD]
[/TR]
[TR]
[TD]Sales ---->[/TD]
[TD="align: right"]800,000.00[/TD]
[TD="align: right"]-3.00[/TD]
[TD="align: right"]420.00[/TD]
[TD="align: right"]-3.00[/TD]
[/TR]
[TR]
[TD]Appointments ---->[/TD]
[TD="align: right"]2,800,000.00[/TD]
[TD="align: right"]-2.00[/TD]
[TD="align: right"]440.00[/TD]
[TD="align: right"]-2.00[/TD]
[/TR]
[TR]
[TD]Qualified Leads --->[/TD]
[TD="align: right"]13,000,000.00[/TD]
[TD="align: right"]-1.00[/TD]
[TD="align: right"]540.00[/TD]
[TD="align: right"]-1.00[/TD]
[/TR]
[TR]
[TD]Initial Leads---->[/TD]
[TD="align: right"]33,333,000.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]720.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]800.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]800.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
I had to think about this. You do have to use fixed horizontal axes. Primary runs from -40,000,000 to +40,000,000; secondary runs from 0 to 800.

If the primary x-axis runs from -40,000,000 to +40,000,000, it has a range, max minus min, of 80,000,000.
We'll set the secondary axis to run from zero to 800. That will give us a conversion factor of 1/100,000—each secondary axis unit equals 100,000 primary axis units.

We know:
-40 M primary equals 0 secondary
0 M primary equals 400 secondary
+40 M primary equals 800 secondary

If we add 40 M to each of those three left-hand values:
-40 M plus 40 M equals 0 M
0 M plus 40 M equals 40 M
+40 M plus 40 M equals 80 M

Now we just have to convert those primary scale results to the secondary axis units:
(0 M) * 1/100,000 = 0
(40 M) * 1/100,000 = 400
(80 M) * 1/100,000 = 800

The scatter chart x values start in B5. That cell contains the value -33,333,000. The Excel formula for the conversion is:
=(B5 + 40000000) / 100000
 Then copied downward.


<tbody>
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, width: 69"]Area Chart[/TD]
[TD="class: xl66, width: 64"][/TD]

[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"]Y Value[/TD]

[TD="class: xl66"][/TD]
[TD="class: xl66"]Scatter Plot[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]0[/TD]
[TD="class: xl66, align: right"]0[/TD]

[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"]Y Value[/TD]
[TD="class: xl66, align: right"]0[/TD]
[TD="class: xl66, align: right"]0[/TD]

[TD="class: xl66"][/TD]
[TD="class: xl67, align: right"]-33,333,000[/TD]
[TD="class: xl66, align: right"]0[/TD]
[TD="class: xl67, align: right"]67[/TD]
[TD="class: xl66, align: right"]0[/TD]

[TD="class: xl66"][/TD]
[TD="class: xl67, align: right"]-13,000,000[/TD]
[TD="class: xl66, align: right"]-1[/TD]
[TD="class: xl67, align: right"]270[/TD]
[TD="class: xl66, align: right"]-1[/TD]

[TD="class: xl66"][/TD]
[TD="class: xl67, align: right"]-2,800,000[/TD]
[TD="class: xl66, align: right"]-2[/TD]
[TD="class: xl67, align: right"]372[/TD]
[TD="class: xl66, align: right"]-2[/TD]

[TD="class: xl66"][/TD]
[TD="class: xl67, align: right"]-800,000[/TD]
[TD="class: xl66, align: right"]-3[/TD]
[TD="class: xl67, align: right"]392[/TD]
[TD="class: xl66, align: right"]-3[/TD]

[TD="class: xl66"][/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl66, align: right"]-3[/TD]
[TD="class: xl67, align: right"]400[/TD]
[TD="class: xl66, align: right"]-3[/TD]

[TD="class: xl66"][/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl66, align: right"]-3[/TD]
[TD="class: xl67, align: right"]400[/TD]
[TD="class: xl66, align: right"]-3[/TD]

[TD="class: xl66"]Sales ---->[/TD]
[TD="class: xl67, align: right"]800,000[/TD]
[TD="class: xl66, align: right"]-3[/TD]
[TD="class: xl67, align: right"]408[/TD]
[TD="class: xl66, align: right"]-3[/TD]

[TD="class: xl66"]Appointments ---->[/TD]
[TD="class: xl67, align: right"]2,800,000[/TD]
[TD="class: xl66, align: right"]-2[/TD]
[TD="class: xl67, align: right"]428[/TD]
[TD="class: xl66, align: right"]-2[/TD]

[TD="class: xl66"]Qualified Leads --->[/TD]
[TD="class: xl67, align: right"]13,000,000[/TD]
[TD="class: xl66, align: right"]-1[/TD]
[TD="class: xl67, align: right"]530[/TD]
[TD="class: xl66, align: right"]-1[/TD]

[TD="class: xl66"]Initial Leads---->[/TD]
[TD="class: xl67, align: right"]33,333,000[/TD]
[TD="class: xl66, align: right"]0[/TD]
[TD="class: xl67, align: right"]733[/TD]
[TD="class: xl66, align: right"]0[/TD]

[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]800[/TD]
[TD="class: xl66, align: right"]0[/TD]

[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]800[/TD]
[TD="class: xl66, align: right"]0[/TD]

</tbody>
 
Last edited:
Upvote 0
Well, first I would like to commend you for cracking the sales/conversion funnel. I have not found any solution that works dynamically like this.

Can you think of any way to shade the various stages in different colors (i.e. Y=0 to -1, Y=-1 to -2, Y=-2 to -3)? This would show the journey along the sales path and make this the perfect solution.
 
Last edited:
Upvote 0
My initial thought was to plot additional areas, like the breakout below. But i'm running into a bunch of issues so I think I'm missing something.

[TABLE="width: 130"]
<tbody>[TR]
[TD="colspan: 2"][TABLE="width: 130"]
<tbody>[TR]
[TD="colspan: 2"]Area 1[/TD]
[/TR]
[TR]
[TD]X Value[/TD]
[TD]Y Value[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]80[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]260[/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: right"]540[/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: right"]720[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]800[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Area 2[/TD]
[/TR]
[TR]
[TD]X Value[/TD]
[TD]Y Value[/TD]
[/TR]
[TR]
[TD="align: right"]260[/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: right"]360[/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: right"]440[/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: right"]540[/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Area 3[/TD]
[/TR]
[TR]
[TD]X Value[/TD]
[TD]Y Value[/TD]
[/TR]
[TR]
[TD="align: right"]360[/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: right"]390[/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: right"]400[/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: right"]400[/TD]
[TD="align: right"]-2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Last edited:
Upvote 0
@thisoldman.... we just created the best conversion funnel graphic available on the web.... I wish I knew how to post pictures on here... plug this data in and take a look. Thank you very much!


  • 1 scatter plot
  • 4 area charts (I added an extra layer for "the lip" of the funnel)

[TABLE="width: 641"]
<colgroup><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"]4 AREA CHARTS ---- (X2,Y2); (X2,Y3); (X2,Y4); (X2,Y5)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]X2[/TD]
[TD="align: right"]Y2[/TD]
[TD="align: right"]Y3[/TD]
[TD="align: right"]Y4[/TD]
[TD="align: right"]Y5[/TD]
[/TR]
[TR]
[TD="colspan: 2"]1 SCATTER PLOT[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="align: right"]X1[/TD]
[TD="align: right"]Y1[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="align: right"]-32,000,000[/TD]
[TD="align: right"]0.0[/TD]
[TD][/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="align: right"]-32,000,000[/TD]
[TD="align: right"]-0.5[/TD]
[TD][/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]-0.50[/TD]
[TD="align: right"]-0.50[/TD]
[TD="align: right"]-0.50[/TD]
[TD="align: right"]-0.50[/TD]
[/TR]
[TR]
[TD="align: right"]-14,000,000[/TD]
[TD="align: right"]-1.5[/TD]
[TD][/TD]
[TD="align: right"]260[/TD]
[TD="align: right"]-1.50[/TD]
[TD="align: right"]-1.50[/TD]
[TD="align: right"]-1.50[/TD]
[TD="align: right"]-0.50[/TD]
[/TR]
[TR]
[TD="align: right"]-4,000,000[/TD]
[TD="align: right"]-2.5[/TD]
[TD][/TD]
[TD="align: right"]360[/TD]
[TD="align: right"]-2.50[/TD]
[TD="align: right"]-2.50[/TD]
[TD="align: right"]-1.50[/TD]
[TD="align: right"]-0.50[/TD]
[/TR]
[TR]
[TD="align: right"]-1,000,000[/TD]
[TD="align: right"]-3.5[/TD]
[TD][/TD]
[TD="align: right"]390[/TD]
[TD="align: right"]-3.50[/TD]
[TD="align: right"]-2.50[/TD]
[TD="align: right"]-1.50[/TD]
[TD="align: right"]-0.50[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]-3.5[/TD]
[TD][/TD]
[TD="align: right"]400[/TD]
[TD="align: right"]-3.50[/TD]
[TD="align: right"]-2.50[/TD]
[TD="align: right"]-1.50[/TD]
[TD="align: right"]-0.50[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]-3.5[/TD]
[TD][/TD]
[TD="align: right"]400[/TD]
[TD="align: right"]-3.50[/TD]
[TD="align: right"]-2.50[/TD]
[TD="align: right"]-1.50[/TD]
[TD="align: right"]-0.50[/TD]
[/TR]
[TR]
[TD="align: right"]1,000,000[/TD]
[TD="align: right"]-3.5[/TD]
[TD][/TD]
[TD="align: right"]410[/TD]
[TD="align: right"]-3.50[/TD]
[TD="align: right"]-2.50[/TD]
[TD="align: right"]-1.50[/TD]
[TD="align: right"]-0.50[/TD]
[/TR]
[TR]
[TD="align: right"]4,000,000[/TD]
[TD="align: right"]-2.5[/TD]
[TD][/TD]
[TD="align: right"]440[/TD]
[TD="align: right"]-2.50[/TD]
[TD="align: right"]-2.50[/TD]
[TD="align: right"]-1.50[/TD]
[TD="align: right"]-0.50[/TD]
[/TR]
[TR]
[TD="align: right"]14,000,000[/TD]
[TD="align: right"]-1.5[/TD]
[TD][/TD]
[TD="align: right"]540[/TD]
[TD="align: right"]-1.50[/TD]
[TD="align: right"]-1.50[/TD]
[TD="align: right"]-1.50[/TD]
[TD="align: right"]-0.50[/TD]
[/TR]
[TR]
[TD="align: right"]32,000,000[/TD]
[TD="align: right"]-0.5[/TD]
[TD][/TD]
[TD="align: right"]720[/TD]
[TD="align: right"]-0.50[/TD]
[TD="align: right"]-0.50[/TD]
[TD="align: right"]-0.50[/TD]
[TD="align: right"]-0.50[/TD]
[/TR]
[TR]
[TD="align: right"]32,000,000[/TD]
[TD="align: right"]0.0[/TD]
[TD][/TD]
[TD="align: right"]720[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]-40,000,000[/TD]
[TD]X min[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD]X min[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]40,000,000[/TD]
[TD]X max[/TD]
[TD][/TD]
[TD="align: right"]800[/TD]
[TD]X max[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
you can post a link to a hosted cloud service, something reputable and well known without a password of joining requirement
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
Plot degrees instead of x,y axis on scatter chart
Replies
0
Views
895
arthurz11
A
E
  • Question Question
Plotting more than 2 data ranges in a scatter chart
Replies
1
Views
781
Anthony47
A
J
  • Question Question
Scatter Plot Graph - Issue with x-axis Label
Replies
1
Views
787
RoryA
RoryA
D
  • Solved
How to pull data from an exponential trendline chart automatically to a cell.
Replies
3
Views
3K
BSALV
BSALV
K
  • Question Question
issues with setsourcedata
Replies
1
Views
866
Domenic
D

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

Share this page

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
Back
Top