Determining Height formula for Milestone Chart

[DashboardNovice]

On the following page http://chandoo.org/wp/2009/07/09/project-milestones-in-timeline/
I am trying to determine the formula for calculating the value in the height column of the milestone table.

The downloaded file doesn't have the formula in there.

Any ideas?

 

[NARAYANK991]

Hi ,

If you want a simple formula , which helps to separate the labels from one another , try this in D20 :

=IF(C20="",0,IF(ISODD(COUNTA($C$20:C20)),1,2))

Copy down.

Narayan

 

[DashboardNovice]

Hi ,

If you want a simple formula , which helps to separate the labels from one another , try this in D20 :

=IF(C20="",0,IF(ISODD(COUNTA($C$20:C20)),1,2))

Copy down.

Narayan

Thank you for your reply. I tried this, but your formula returns either a 0,1 or 2. The examples also have 3 and 4 as values. How do you get 3 and 4?

 

[NARAYANK991]

Hi ,

The example file had 3 and 4 because they were just manually entered values ; if you want the same pattern , the formula will be more complex ; try this :

=IF(C20="",0,IF(COUNTA($C$20:C20)<=COUNTA($C$20:$C$31)/2,COUNTA($C$20:C20),COUNTA(C20:$C$31)))

Narayan

 

[DashboardNovice]

Hi ,

The example file had 3 and 4 because they were just manually entered values ; if you want the same pattern , the formula will be more complex ; try this :

=IF(C20="",0,IF(COUNTA($C$20:C20)<=COUNTA($C$20:$C$31)/2,COUNTA($C$20:C20),COUNTA(C20:$C$31)))

Narayan

Very nice. This was very helpful. Thank you.