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

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

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 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

Sort by » oldest newest most voted

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.

more

Oh that worked! thank you very much!

( 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.

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

## Stats

Seen: 616 times

Last updated: Aug 06 '17