To display bar graph of selected months

[Shamz41]

Hi. In cell L1, I have a month and year criteria. I need to display the data from the table range in A1:G13 of the month in cell L1 and the previous month before that. In the is example the bar graph data of Jun 18 and May 18. Can i know how this can be done?

[bebo021999]

Using helper table to get data
See atchment.

[Shamz41]

Hi Bebo. Thank you very much for the formula. It worked to an extend. I realised that when i typed in the month of Jan 17, Jan 18, the months in K2 and K3 shows both as jan instead of dec and jan. Able to assist on this?

[bebo021999]

My fault. Try again:
In K2:

Please Login or Register  to view this content.

K3:

Please Login or Register  to view this content.

L2:

Please Login or Register  to view this content.

L3:

Please Login or Register  to view this content.