Best viewing for margin analysis

[Samir69]

Hi Forum
I want to know what is for you the best vizualisation for margin analysis ?

I built a graph but for me the viewing is a little simple, would there be an alternative ?



Thanks

 

[NARAYANK991]

Hi Samir ,

Is this one ?

http://www.waterfall-chart.com/Content/gross-margin-analysis-waterfall-chart-for-excel.png

Narayan

 

[Debraj]

I think, Cycle Plot Graph, will work best in this scenario.

 

[Debraj]

An Average line will also increase its looks and Trend View.

 

[Samir69]

hi deb hi narayank

Thanks for your solution

Deb it is a very interesting way to show margin data. But how have you integrated an arrow at the end of the curve ?

Thanks

 

[Debraj]

Hi Samir,

Right Now, I don't have Excel < 2013 version, just a rough idea,
Select the line, and Press Ctrl + F1, in Line Color / Type section, search for End Type Dropdown..