How to plot the bar only 1 bar per year ?

[paulyeo11]

Hi All

Table 1 have stock amount by month from 1996 Jan till 2016 march.

Chart 1 shown the bar chart for stock amount from 1996 Jan till 2016 March.

My question is how to make the chart 1 to display average stock for only every mach ?

Meaning it will display bar show as following :-

2016 march

2015 march

2014 march

and so on...

Paul

[paulyeo11]

Hi sunny

I think I need to start with Jan 1996 month to compute the closing stock amount and using the value as opening stock for Feb 1996 and sun the stock transaction of Feb to compute the closing stock for 1997 Feb and so on. I think if I give you the info you should be able to give me what I want on average stock.

Now I need to enter the plane . Thank you very much .

Paul

Sent from my iPhone

[paulyeo11]

Hi Sunny

For 2016 , since it only have 3 month , so i need to divide by 3.

Paul

[paulyeo11]

Hi Sunny

After rest for few days , i test on the your expression again , this time i notice that the yearly stock number is correct.

Thank

Paul