Show growth in the bar chart

N

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.
 
D

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.
Click to expand...

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:
Click to expand...

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

Needhelp

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding CAGR line to Column Chart 0
Combination charting with two axis 1
Plotting moving average line on a chart 1
*URGENT* Adding a Scroll Bar to a chart 1
offset scatter plot points 1
Problem w/X axis in chart (2003) 3
Creating separate graphs for columns of data 1
Complex Date chart question 2

Top