Date format in Visual Reports Project 2016 RRS feed

  • Question

  • Hi,

    I'm using the Visual Report: Earned Value Over Time Report in MS Project 2016

    The X axis in Excel represents the dates as Week number in the year or Day number in the month.

    Is it possible to represent these dates as true dates with the format mm/dd/yy or dd/mm/yy.

    Thanks for your help

    Thursday, October 4, 2018 5:28 PM

All replies

  • Double click on axis to pull up the properties

    From format axis, look down to the category and select Date format.  Once date format is select, you can select different formats of dates.

    Michael Wharton, Project MVP, MBA, PMP and a Great Guy <br/> Website <br/> Blog contains my field notes and SQL queries

    Friday, October 5, 2018 2:10 AM
  • Thanks Michael,

    I did that and selected a date format, but in the X axis I still have only the week numbers :

    Week 1, Week 2, Week 3,...Week 52

    Any idea?


    It seems that week numbers are not recognized as date format :(

    • Edited by WLID1966 Friday, October 5, 2018 5:01 PM
    Friday, October 5, 2018 9:57 AM