PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting 3D Funnel Chart

Reply

3D Funnel Chart

 
Thread Tools Rate Thread
Old 09-07-2008, 06:22 PM   #1
giovanni
Guest
 
Posts: n/a
Default 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
  Reply With Quote
Old 10-07-2008, 12:41 PM   #2
Jon Peltier
Guest
 
Posts: n/a
Default Re: 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 here:

http://peltiertech.com/WordPress/20...s-funnel-chart/

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


"giovanni" <giovanni@discussions.microsoft.com> wrote in message
newsFA48EB3-4812-43C0-A294-28B68E59E40F@microsoft.com...
> 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



  Reply With Quote
Old 10-07-2008, 06:40 PM   #3
giovanni
Guest
 
Posts: n/a
Default Re: 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
  Reply With Quote
Old 10-07-2008, 06:55 PM   #4
Jon Peltier
Guest
 
Posts: n/a
Default Re: 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" <giovanni@discussions.microsoft.com> wrote in message
news:8916B9ED-E1CE-49B9-A1A2-B2561FA11918@microsoft.com...
> 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



  Reply With Quote
Old 10-07-2008, 07:43 PM   #5
Del Cotter
Guest
 
Posts: n/a
Default Re: 3D Funnel Chart

On Thu, 10 Jul 2008, in microsoft.public.excel.charting,
Jon Peltier <jonxlmvpNO@SPAMpeltiertech.com> 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 del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.
  Reply With Quote
Old 10-07-2008, 09:05 PM   #6
Jon Peltier
Guest
 
Posts: n/a
Default Re: 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" <del@branta.demon.co.uk> wrote in message
news:ijj1tzAAhldIFwFO@branta.demon.co.uk...
> On Thu, 10 Jul 2008, in microsoft.public.excel.charting,
> Jon Peltier <jonxlmvpNO@SPAMpeltiertech.com> 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
> del@branta.demon.co.uk,
> which goes to a spam folder-- please send your email to del3 instead.



  Reply With Quote
Old 11-07-2008, 07:49 AM   #7
giovanni
Guest
 
Posts: n/a
Default Re: 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ò

  Reply With Quote
Old 11-07-2008, 11:38 AM   #8
Ed Ferrero
Guest
 
Posts: n/a
Default Re: 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)

  Reply With Quote
Old 11-07-2008, 12:10 PM   #9
giovanni
Guest
 
Posts: n/a
Default Re: 3D Funnel Chart

Thank you Ed for your kind cooperation;


  Reply With Quote
Old 11-07-2008, 02:33 PM   #10
Jon Peltier
Guest
 
Posts: n/a
Default Re: 3D Funnel Chart


"Ed Ferrero" <ed@edferrero_remove_.com> wrote in message
news:956F86AE-7D93-4892-967D-39C180A4FF99@microsoft.com...
> 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
_______


  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off