ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Pipeline Chart/Stacked Chart (https://www.excelbanter.com/charts-charting-excel/228474-pipeline-chart-stacked-chart.html)

ogerriz

Pipeline Chart/Stacked Chart
 
Is it possible to create a pipe or stacked chart that will show the values of
the pipeline? What we wish to see is that if the values are the same in all
the weighting stages, then the pipe will be almost a straight or tubular
shape; whereas the way it looks now, it will actually be a bit lumpy in the
middle stages depending on what we have in the works?


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


Hope someone can help me with this one as I tried the stacked pyramid and it
didn't actually show me the actual shape of my pipeline...

Thanks


Tushar Mehta[_4_]

Pipeline Chart/Stacked Chart
 
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:

Is it possible to create a pipe or stacked chart that will show the values of
the pipeline? What we wish to see is that if the values are the same in all
the weighting stages, then the pipe will be almost a straight or tubular
shape; whereas the way it looks now, it will actually be a bit lumpy in the
middle stages depending on what we have in the works?


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


Hope someone can help me with this one as I tried the stacked pyramid and it
didn't actually show me the actual shape of my pipeline...

Thanks



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

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