View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
NeedHelp NeedHelp is offline
external usenet poster
 
Posts: 23
Default Show growth in the bar chart

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.