We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

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

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

fernandodx gravatar image


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


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

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:


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

edit flag offensive delete link more


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


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

Seen: 616 times

Last updated: Aug 06 '17