Hi,
Can somne tell me the name of the below chart ( i beleive its bridge chart) and how to draw this chart in the exact same way as shown in the image
Hi,
Can somne tell me the name of the below chart ( i beleive its bridge chart) and how to draw this chart in the exact same way as shown in the image
its a waterfall chart aka bridge chart
http://peltiertech.com/WordPress/exc...bridge-charts/
but you might need an addin
http://office.microsoft.com/en-us/te...030002352.aspx
http://www.add-ins.com/waterfall_charts.htm
Last edited by martindwilson; 07-07-2012 at 06:03 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
It's Different from the other Waterfall charts, if you see the word document that i attached in the 1st blog .... you will see the Positive and Negitive values on the same axis ..... in normal charts the negitvie value comes below the 0 value bit in this one the value are on the same line. is it theat they have used the two axis points(two way graph/chart)
You can create that chart using a 3 series stacked bar.
You need a series for negative values, one to pad positive values and one for the positive values.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks