Gantt Chart Dates

[#1]

I have a Gantt Chart that I have created.  I have used the Max - Min formula, and also set the expression as a number.  I have a total of 3 expressions:

Max - Min:  MAX([End Date])-MIN([Start Date])

a Count: =Num(count(DISTINCT[Project ID]),'##,###')   (This is to remove some duplicate project IDs)

Interval of Max - Min:  interval(Max ([End Date] )-Min ([Start Date]),'D') & ' days'

The first Max - Min I have set as a Date (the 2 date fields used are also dates in the source file)

The last 2 expressions are set to expression default

Any help would be greatly appreciated!

[#2]

I guess you need to add Bar Off set and also Unselect the Forced to Zero on Axis tab.

[#3]

I am not sure I know what you mean by "addBar Off set".  I also do not have Forced 0 selected on the axis tab.

[#4]

I did some research and added the Bar Offset, thank you so much, that did the trick!

[arthur_dom]

Maybe this help

Recipe for a Gantt chart

[#6]

thank you, I did use that when I created the chart.  I had to use the Bar Offset in order to make it work.

[pablomind]

I have a question for you Silvia. Im working with the same chart and everything perfect except that the dates label showed in the x axis show the months 7 to 7 (Jan to July and on and on). By any chance do you know a way how to show all the months in this chart (Jan,Feb,etc)?

[#8]

Unfortunately I do not.  I have figured out how to change the start and end dates, but as for the intervals within, I do not, I am sorry.