Gantt chart issue

[davidstokes]

Hi all,

Just making a gantt chart for the first time and i'm running into issues.

I've attached a screenshot of the chart and data, but for some reason the date at the time is going back to 31st March

I've set the start day based on B2 and i'm not sure how to fix this issue.

Does anyone know what i've done wrong and why it's not starting at the 1st date ?

 

[VBA Geek]

You need to adjust the max and min of the axis

min should be 43212 (22 april) and max 43247 (27 may)

 

[davidstokes]

How did you get those min and max ? .. like how did you know 22april =43212 ?

Thanks it worked. But interested how you know the numbers ?

 

[VBA Geek]

How did you get those min and max ? .. like how did you know 22april =43212 ?

Thanks it worked. But interested how you know the numbers ?

type a date in a cell then convert the cell to General format

 

[davidstokes]

type a date in a cell then convert the cell to General format

Thanks. Helps be a ton.

Thank you.