ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   connecting bar graphs (https://www.excelbanter.com/charts-charting-excel/228725-connecting-bar-graphs.html)

ogerriz

connecting bar graphs
 
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[_3_]

connecting bar graphs
 
Hi ogerriz,

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

Ed Ferrero

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



Tushar Mehta[_4_]

connecting bar graphs
 
The pipeline chart
http://www.tushar-mehta.com/excel/ch...line/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


"ogerriz" wrote:

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



All times are GMT +1. The time now is 01:01 PM.

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