View Single Post
 
Old 05-03-2017, 03:41 AM
Minesh Minesh is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: May 2017
Posts: 1
Minesh is on a distinguished road
Default Project 2013 Report

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
File Type: png Capture.PNG (13.8 KB, 18 views)
Reply With Quote