Dear all,
I am having a random issue with a chart while creating a custom report. Currently I am creating a 'Master project plan' which incorporates a number of individual subproject in one place and from those trying to create a master project dashboard/overview report.

I have added a horizontal bar chart to detail each project along with the project duration & % complete details. I've formatted the horizontal axis to detail the date, but this is where my issue lies.
The project dates are set as following:
Start date = 30/01/17
Finish date = 29/05/17
When the data is entered into the chart the axis is stating dates from 30/12/1899 to 09/04/1900.
Does anyone know how I can amend the axis to detail the actual start and finish dates of the specific projects?

Minesh

Attached Images

Capture.PNG (13.8 KB, 20 views)