Hey everyone....I need your help in creating a chart....so basically i have a company with 3 segments w/ corresponding revenues in 2014
2014:
Seg A: 100
Seg B: 200
Seg C: 300
Each segment revenue grows to following number by 2015
2015:
Seg A: 100+10=110
Seg B: 200+20=220
Seg C: 300+30=330
So basically I am trying to build one bar chart with 5 columns
1st column: 2014 stacked revenues
2nd column: Seg A growth of 10 floating above first column
3rd column: Seg B growth of 20 floating above second column
4th column: Seg C growth of 30 Floating above 3rd column
5th column: 2015 Total of 660 (330+220+110)
Kinda like a waterfall chart but for multiple segments...see the attachment for graphics representation....colors should also match for these segments.
Thanks in advance!
Bookmarks