3D Funnel Chart

[giovanni]

Good afternoon everybody,
is there a web site and or someone that could help me in setting up,step
by step a 3D Funnel Chart?
Thank for the help
Giovanni

 

[Jon Peltier]

3D Funnel charts are among the worst graph types you could use. They're
based on a flawed metaphor, and this faulty metaphor makes the graph very
difficult to interpret properly. I describe the problem and offer
alternatives here:

http://peltiertech.com/WordPress/2008/06/29/bad-graphics-funnel-chart/

- Jon

 

[giovanni]

thank you Jon , I know that they are not the best way to show data but I
wouldlike to know how I can build up such a graph; is there a web site
describing step by step how to do that or a pre-cooked examples?
Thank you anyway
Giovanni

 

[Jon Peltier]

These are not available in Excel. I'm sure Google could help you find a
vendor who will sell you a package that produces funnel charts. There's no
step-by-step procedures, it's data in, garbage out.

- Jon

 

[Del Cotter]

These are not available in Excel.

I'm probably going to information graphics hell for this , but you
*can* sort of do a 3D Funnel in Excel:

http://www.branta.demon.co.uk/infographics/3DFunnel.xls

I don't say you *should*, but you can.

 

[Jon Peltier]

If you tell him how you did this, I'm kicking you out of the newsgroup!

- Jon

 

[giovanni]

I will discover how has been done; the important fact is that I have an
example ; credit to Mr. Del Cotter for this. As I said before I know that is
not the best way of showing data but as a matter of fact just to understand
how it is possible to build such a graph.
Thank you again Mr. Del Cotter.
Giò

 

[Ed Ferrero]

Jon Peltier wrote;

If you tell him how you did this, I'm kicking you out of the newsgroup!

LOL

Here is something similar
http://www.edferrero.com/Content/Scatter_Pyramid.xls

Just format the y-Axis and check 'values in reverse order' to get your
funnel.

(oh yes, I think the calculations are wrong, but it hardly matters for this
sort of chart)

Ed Ferrero
"A little inaccuracy sometimes saves a ton of explanation."
- H. H. Munro (Saki) (1870-1916)

 

[giovanni]

Thank you Ed for your kind cooperation;

 

[Jon Peltier]

Jon Peltier wrote;


LOL

Here is something similar
http://www.edferrero.com/Content/Scatter_Pyramid.xls

Just format the y-Axis and check 'values in reverse order' to get your
funnel.

(oh yes, I think the calculations are wrong, but it hardly matters for
this sort of chart)
LOL

Ed Ferrero
"A little inaccuracy sometimes saves a ton of explanation."
- H. H. Munro (Saki) (1870-1916)

LOLx2

- Jon

 

[Bob Flanagan]

Jon, I don't know how you did it, bu the page on 3D charts is no longer
available! <GRIN>

Bob Flanagan

 

[Jon Peltier]

You mean Ed's page? That was a well-placed burst of gamma rays.

- Jon