Hi All
I was wondering whether someone could advise.
I have been following this tutorial on Dashboards:
https://www.powerusersoftwares.com/single-post/2016/10/17/How-to-create-impressive-Excel-dashboards
I'm using a pivot table to create a pivot gantt chart. I have a list of "projects" as well as a list of start dates and auto calculated duration days within the table which is then subsequently pulled through on to the pivot chart.
For some of these projects however, the date is not pulling through correctly, instead it is wildly off i.e. 2129.
I have tried everything I can think of, however it is only a specific few which are not being shown correctly like the others.
Has anyone experienced this before? Can anyone advise?
I was wondering whether someone could advise.
I have been following this tutorial on Dashboards:
https://www.powerusersoftwares.com/single-post/2016/10/17/How-to-create-impressive-Excel-dashboards
I'm using a pivot table to create a pivot gantt chart. I have a list of "projects" as well as a list of start dates and auto calculated duration days within the table which is then subsequently pulled through on to the pivot chart.
For some of these projects however, the date is not pulling through correctly, instead it is wildly off i.e. 2129.
I have tried everything I can think of, however it is only a specific few which are not being shown correctly like the others.
Has anyone experienced this before? Can anyone advise?
