Stacked Bar chart date issue

petermikula

New member
Joined
Feb 21, 2017
Messages
1
Reaction score
0
Points
0
I'm using a project mgmt excel dashboard which included a stacked bar chart. The template had dates from 2015, I"m using it for project which has dates from 2017 on. The chart still "thinks" it needs to show on the axis 2015 dates which makes the gannt chart inaccurate . However the data source does not have any 2015 tasks. I tried different things but looks to me like a bug or something.

I have attached a sample

Please advise how to fix the gantt chart that pulls data from the notes table

Thanks a lot!

Peter
 

Attachments

  • Project Management Dashboard Template - Copy.xlsx
    34.5 KB · Views: 22
Right-click the axis legend at the top to open the axis format dialog. In the axis options section, change the minimum bounds value to 42980.0.
 

Attachments

  • Project Management Dashboard Template - AliGW.xlsx
    34.4 KB · Views: 28
Back
Top