Excel chart for stock in , stock out ..

[Alena]

Hello Chandoo,
Thank you for your website, I like to play with excell and surprise HQ every month with a new look of my report.
I am thinking how to show movement of stock in WH, for example :


Material begin. stock stock in stock out remain stock
a 28386 42020 -40098 30,308
b 73193 97514 -75491 95,216
c 14585 14400 -12605 16,380
d 31445 23662 -26849 28,258
e 143530 0 -35065 108,465








I would like to have a chart when I can show amount of stock I have and its movement up and down by month.
What do you think ??
Thank you
Wish you all the best, Alena

 

[srinidhi]

Hi,
Find attached the workbook, hope this help you. This is a combination of 2 charts.

 

[Alena]

Hello,
Thank you very much for your chart.
I change it a litlle by by using secondary axis and line chart for beginning and reminding stok, but it is still not smooth floow as I wished for.
To tell the true I was looking for something more cool :-D.
Thank you anyway , you was only one who replied.
Have an interesting day !