Ask Your Question
1

A Stacked Bar Gantt Chart in Calc that excludes weekends. [closed]

asked 2017-08-05 18:38:02 +0200

fernandodx gravatar image

Hello!

Searching around some tutorials I've managed to make a Gantt chart in Calc using the stacked bar chart

But i didn't managed to exclude weekends from the Y scale

(I Tried attaching the image here but says I need more than 3 points to do so, so I uploaded it here: http://imgur.com/a/vQJmp )

Using workday function from "task 2" onward the cells shows the correct value, but i am not sure how to adjust the scale to exclude weekends

What I'm trying to do is possible? (I'm using version 5.1.6.2)

Thanks!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by fernandodx
close date 2017-08-06 16:49:16.597204

1 Answer

Sort by » oldest newest most voted
1

answered 2017-08-06 03:14:33 +0200

librebel gravatar image

Hello @fernandodx,

If i understand it correctly, then your column C contains the Duration in Workdays, and what you actually want is the Duration in Weekdays.

The difference between the Duration in Weekdays and the Duration in Workdays is 2, if the duration contains a weekend.

A simple solution might then be if you just created a new column for the Duration in Weekdays, with a formula like:

=DAYS(WORKDAY(B2;C2);B2)

Then set this new column in your chart instead of column C.

edit flag offensive delete link more

Comments

Oh that worked! thank you very much!

fernandodx gravatar imagefernandodx ( 2017-08-06 16:48:56 +0200 )edit

Glad to read it worked @fernandodx, In order to mark the right answer as accepted before closing the question, please click on the ✔ symbol at the left side of the question, until it turns green.

librebel gravatar imagelibrebel ( 2017-08-06 17:49:54 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2017-08-05 18:38:02 +0200

Seen: 259 times

Last updated: Aug 06 '17