connecting bar graphs

[ogerriz]

I have a bar graph plotting

Weighting
100% 90% 70% 20% 10% 9% 1% Grand Total
Pipeline 2 21 19 39 4 1 10 96


I would like to centre all the bars (the length of the bar shows the
size/amount) so I want to take those bars, centre it and then connect all the
ends so that it forms a solid object.

Is that possible? I will be using it to show a pipe-like or funnel-like
object.

thanks

 

[Ed Ferrero]

Hi ogerriz,

Sounds like you may want to look at this;
http://peltiertech.com/Excel/Charts/tornadochart.html

Ed Ferrero

 

[Tushar Mehta]

The pipeline chart
http://www.tushar-mehta.com/excel/charts/pipeline/index.htm

--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu