excel - Chart Open Orders by Month Using Open and Close Dates -

problem statement:
have orders in excel dates orders opened, , date order closed. i'd show chart month showing number of orders open during given month.

what i've done:
created column each month, created formula returns 1 or 0 based on whether open during month. sum total @ bottom of column

what i'm looking for:
different solution, 1 may lead pivot table make easier incorporate other data fields, instance type of product etc.

assuming have looks like:

and want have ability produce pivot table , chart like:

you transpose data , create column headings similar has been done @ top of second picture.