Show growth in the bar chart

[Needhelp]

Hi,

I would like to create a bar chart from the following data:

First period: 71
Second period: 110
Growth from first period to second period: 110-71 = 39
- Assume that the growth of 39 is attributed to the two drivers.
- The first driver contributes 20 and the second contributes 19.

The chart would look like:

71 110 39 20 19
+----+ +----+ +-----+
| | | | | |
| | | | +------+ +-----+
| | | | | |
+----+ | | +----+ +-----+
| | | |
| | | |
| | | |
+----+ +----+
1st 2nd Growth 1st driver 2nd driver
period period

Could anyone let me know how to create this type of chart in MS Excel?

Thank you very much.

 

[John Mansfield]

Jon Peltier provides a series of floating column and waterfall charting
examples on his site that will work for you. Please see the links below:

http://www.peltiertech.com/Excel/Charts/Waterfall.html

http://www.peltiertech.com/Excel/Charts/waterfallcrossing.html

Jon has also created an Excel utility that does the work for you. You might
want to try it via the link below:

http://www.peltiertech.com/Excel/Charts/WaterfallUtility.html

 

[Del Cotter]

I would like to create a bar chart from the following data:

First period: 71
Second period: 110
Growth from first period to second period: 110-71 = 39
- Assume that the growth of 39 is attributed to the two drivers.
- The first driver contributes 20 and the second contributes 19.

It needs to be a stacked column chart with the first in the stack
formatted to be invisible (no area and no borders). The numbers will
look like this:

1stPer 2ndPer Growth 1stDriv 2ndDriv
Invisible 0 0 =110-39 =110-20 =110-39
Visible 71 110 39 20 19

The chart would look like:

Also, google "Excel waterfall-chart" for more examples.

 

[Needhelp]

Thanks much!

Jon Peltier provides a series of floating column and waterfall charting
examples on his site that will work for you. Please see the links below:

http://www.peltiertech.com/Excel/Charts/Waterfall.html

http://www.peltiertech.com/Excel/Charts/waterfallcrossing.html

Jon has also created an Excel utility that does the work for you. You might
want to try it via the link below:

http://www.peltiertech.com/Excel/Charts/WaterfallUtility.html