Funnel charts

Does anyone have experience / know how to create a Sales Funnel Chart?
Basically a funnel is divided into 3 areas: top is "all opportunities" (one cell in a spread sheet), middle is "my opportunities" (second cell in a spread sheet) and bottom is "po's" (third cell in a spread sheet). As an added complexity, it would be nice if the overall size of the funnel was proportional to the total sales (big $ region has big funnel, small $ region has small funnel) - this is not necessary but desirable.

It may be that a cone chart is what you want

select your data and choose chart type, standard type, cones. and pick
the 'stacked' option

select one of the series the click format data series, options.
chanig the chart depth to 20 emphasises that different heights
represent different values

setting the gap width to aroud 30 inserts small spaces between the
cones.


---
Message posted from http://www.ExcelForum.com/