Help with Pivot Charts

[JJAce]

Hi, new member to the forum here. Your help would be much appreciated.

I'm beginning to build a dynamic dashboard to show the current state and availability of system environments however I'm struggling with displaying the data in the correct format that I want from a pivot table and chart.

I have a list of environments with several variables. I’m trying to show if the environments are currently being used and if they are, when it becomes available to use again. I have a 'booked from' column and 'booked to' column and also a 'Duration' column which calculates the days from booked to end date.
I want a bar chart to show the Names of the environments down the y axis and months along the x axis to show when the use of environment finishes. However I have been trying to figure out how to show this for hours. Yes hours! It seemed pretty straight forward in my head but struggling to implement. I can’t seem to get the x axis to show the months. Note: I want the x axis date to start from earliest 'Booked from' date. Please see example of data below.

Application Environment Type Status Project Owner Server Name Database Name Booked from Booked until Length Housing HOULIVE LIVE In Use BAU Service Management HSRV_1 HSRVDB_1 1-Feb-18 20-Dec-18 322 Finance HOULIVE LIVE In Use BAU Service Management FSRV_1 FSRVDB_1 1-Feb-18 20-Dec-18 322 Kirona HOULIVE LIVE In Use BAU Service Management KISRV_1 KISRVDB_1 1-Feb-18 20-Dec-18 322 Housing HOUDEV1 DEV In Use Asset Joe Bloggs HOUDE1VSRV HOUDEV1DB 1-Feb-18 20-Mar-18 47 Housing HOUDEV2 DEV In Use CRM Julie Smith HOUDEV2SRV HOUDEV2DB 1-Feb-18 10-Jun-18 129 Finance HOUDEV2 DEV In Use CRM Julie Smith FDEV2SRV FDEV2DB 1-Feb-18 10-Jun-18 129 CRM UAT1 TEST In Use CRM Julie Smith UAT1SRV UAT1DB1 1-Feb-18 10-Jun-18 129 Finance UAT2 TEST Free Free Free UAT2SRV UAT1DB1 1-Feb-18 1-Feb-18 0 Qlikview TRAIN1 TRAINING In Use CRM Julie Smith TRAINSRV TRAIN1 1-Feb-18 10-Jun-18 129 <tbody> </tbody>

<tbody>
</tbody>

Any help or advice on how I can achieve this?

Thanks,