Require help in customization of stock chart in excel

[Bhargavasharma]

Dear all,

My name is Bhargava Sharma , i work as financial analyst in the banking industry.

With reference to the stock chart in the excel, i was unable to customise the bars in the excel sheet.

Require your help/suggestion on the above lines.

With Regards,
Bhargava Sharma V

 

[Debraj]

Hi Bhargava

Can you please upload a sample file.. where you are facing problem with bars..

 

[Bhargavasharma]

Dear Debraj,

PFA

 

[Debraj]

Hi Bhargav

In this scenario.. you can use Stacked Bar Chart..
But its need a few customization..

Check the attached.. Formulated and Customized..


Try to adapt it.. and feel free to come back.. if you need any further help..

Curtesy : Ajay

 

[Bhargavasharma]

Thanks a lot, but can you explain how did you do this

 

[Debraj]

Hi Bhargav

Please check the below link for more detail..
http://www.databison.com/how-to-create-waterfall-chart-in-excel-in-2-minutes/