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.

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/Cha...lcrossing.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/Cha...llUtility.html

--
John Mansfield
cellmatrix.net


"Needhelp" wrote:

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.

On Sat, 1 Mar 2008, in microsoft.public.excel.charting,
Needhelp said:
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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Thanks much!

"John Mansfield" wrote:

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/Cha...lcrossing.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/Cha...llUtility.html

--
John Mansfield
cellmatrix.net


"Needhelp" wrote:

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.