Results 1 to 13 of 13

Adding the correct number of working days to the chart, skipping off days

Threaded View

Vitalite Adding the correct number of... 07-15-2017, 02:09 AM
AliGW Re: Adding the correct number... 07-15-2017, 02:10 AM
Vitalite Re: Adding the correct number... 07-15-2017, 02:21 AM
AliGW Re: Adding the correct number... 07-15-2017, 02:20 AM
AliGW Re: Adding the correct number... 07-15-2017, 02:25 AM
Vitalite Re: Adding the correct number... 07-15-2017, 02:41 AM
AliGW Re: Adding the correct number... 07-15-2017, 02:56 AM
Vitalite Re: Adding the correct number... 07-15-2017, 03:10 AM
AliGW Re: Adding the correct number... 07-15-2017, 03:19 AM
Vitalite Re: Adding the correct number... 07-15-2017, 03:24 AM
AliGW Re: Adding the correct number... 07-15-2017, 03:25 AM
Vitalite Re: Adding the correct number... 07-15-2017, 03:26 AM
AliGW Re: Adding the correct number... 07-15-2017, 03:31 AM
  1. #1
    Forum Contributor
    Join Date
    05-20-2017
    Location
    Boston, US
    MS-Off Ver
    Mac 2011
    Posts
    139

    Adding the correct number of working days to the chart, skipping off days

    Hello.

    I understand that according to implicit rules of these wonderful forum it is better to add description of the task into the body of the thread, but in this case I can only explain what I would like to achieve by attaching the file. Sorry about that.

    I would like to create a (stacked bar) chart that takes shows the length of each task, starting at the start date and finishing at the exact finish date, skipping all off days.

    I have three small tables: Plan, Actual, and the table with data for the chart.

    Both the Plan and Actual tables correctly compute the actual finish date based on the number of actual working days, skipping all off-days, which are listed in a separate tab of the workbook.
    But in the third table, which is used for the chart also, I have the starting date and the number of working days. If I use these data points, I do get a nice chart (I want it in exactly this format of a stacked bar chart) but all finish dates are incorrect, of course, because they are computed by simply adding my defined working days to the start date.

    Please, help me to figure out how to make my chart finish each each bar on the correct finish date; how I shall change my plot series, or add some formula so it knows not only the correct start date but also the correct finish date?

    Thank you very much for your help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Adding the correct number of days considering a starting date
    By jmmdic in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-29-2016, 08:44 AM
  2. [SOLVED] Formula Help: Determine days total from arrival to current date then stop adding days
    By Vicious00013 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2016, 12:45 PM
  3. [SOLVED] calculate total number of days between two days based on 365 days year
    By aparunkumar in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-14-2016, 12:51 AM
  4. [SOLVED] Count 6 working days (excluding Sunday, Holidays & half days)
    By eve_star1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-29-2015, 08:00 AM
  5. [SOLVED] Adding Total Number of Days Elapsed and Displaying >31 Days
    By cwwazy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-03-2013, 08:18 AM
  6. Adding 30 working days to a date
    By Dawn V in forum Excel General
    Replies: 3
    Last Post: 06-16-2008, 08:19 AM
  7. [SOLVED] Adding only working days
    By Leon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2005, 04:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1