ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   3D Funnel Chart (https://www.excelbanter.com/charts-charting-excel/194286-3d-funnel-chart.html)

giovanni

3D Funnel Chart
 
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 Chart
 
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 he

http://peltiertech.com/WordPress/200...-funnel-chart/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"giovanni" wrote in message
...
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




giovanni

3D Funnel Chart
 
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

3D Funnel Chart
 
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"giovanni" wrote in message
...
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




Del Cotter

3D Funnel Chart
 
On Thu, 10 Jul 2008, in microsoft.public.excel.charting,
Jon Peltier said:

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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Jon Peltier

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Del Cotter" wrote in message
...
On Thu, 10 Jul 2008, in microsoft.public.excel.charting,
Jon Peltier said:

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.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.




giovanni

3D Funnel Chart
 
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[_2_]

3D Funnel Chart
 
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

3D Funnel Chart
 
Thank you Ed for your kind cooperation;



Jon Peltier

3D Funnel Chart
 

"Ed Ferrero" wrote in message
...
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)


LOL

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


LOLx2

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



Bob Flanagan[_2_]

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

Bob Flanagan

"Jon Peltier" wrote in message
...

"Ed Ferrero" wrote in message
...
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)


LOL

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


LOLx2

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______





Jon Peltier

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bob Flanagan" wrote in message
...
Jon, I don't know how you did it, bu the page on 3D charts is no longer
available! <GRIN

Bob Flanagan

"Jon Peltier" wrote in message
...

"Ed Ferrero" wrote in message
...
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)


LOL

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


LOLx2

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______








All times are GMT +1. The time now is 07:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com