+ Reply to Thread
Results 1 to 2 of 2

Google Sheets: Make a chart with end and starting dates

  1. #1
    Registered User
    Join Date
    07-01-2020
    Location
    South America
    MS-Off Ver
    365
    Posts
    6

    Question Google Sheets: Make a chart with end and starting dates

    Hello, I am working with Google Sheets and I have the attached sample Workbook which was downloaded from Drive.

    What I have:
    • Each task has a start date and an end date.
    • The start date of the first task i.e. C6 will be the first date that has to be plotted since the project starts with this task.
    • Also, each task has a State which determines if the task is: Not started, In progress or Finished (the background color changes accordingly).
    • A section of Comments was created to indicate if the task is delayed i.e. if a not started task or in a progress task are not finished before today's date.
    • NOTE: The date format must be DD/MM/YYYY or DD/MM.

    I need to create in Google Sheets the (incomplete) chart of the attached image.
    • The chart must contain all of the enumerated tasks (in rows) and a period to be determined by me on how many days it progress (in the image it is every 1 week starting from C6) (in columns).
    • Each bar has to be filled depending on the State (red if it were not started, yellow if it is in progress or green if it is finished).
    • To the right of each bar, the duration in days of each task must be shown (in the image they are 12, 20, 9, ...).
    • NOTE: Some tasks are not drawn correctly since it would take me a long time to draw them.

    Is that possible using Google Sheets? How can we do it? Thanks!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by elmit; 05-06-2021 at 08:14 PM.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,462

    Re: Google Sheets: Make a chart with end and starting dates

    I'm not as familiar with Google Sheets charting engine, but it certainly seems possible. What I see in your picture is basically a Gantt chart (which is basically a stacked bar chart with the right combinations of data series). Your picture shows three visible data series; I expect there will need to be some invisible data series in order to get everything lined up correctly. It often seems that most of the work for this is in the spreadsheet -- arranging the data, computing start dates and durations, and so on. Once the spreadsheet is put together, creating the chart should mostly be about inserting a stacked bar chart and formatting the different elements the way you want them formatted.

    Here's a Gantt chart tutorial I found https://www.howtogeek.com/447783/how...google-sheets/ It's simpler than what you are looking for, but it should provide a good starting point for understanding how to build a Gantt chart as a stacked bar chart. Once you understand how the simpler Gantt chart works, then it should be relatively easy to expand it to multiple data series like in your picture.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 02-12-2021, 06:42 PM
  2. Google Sheets: Trying to make a matrix with 1 and 0 based on 3 different tabs in the sheet
    By RobbertDG in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 01-30-2021, 06:30 AM
  3. Timeline Chart in Google Sheets
    By Ian99099 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-19-2021, 07:23 AM
  4. Google Sheets: Looking up next/earliest due date but excluding past dates
    By Fluffybunny in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 09-20-2019, 03:56 AM
  5. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  6. How to make items rise to the top? [Google Sheets]
    By Idler in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 37
    Last Post: 12-12-2015, 03:08 PM
  7. building chart with Google Drive Sheets
    By di-man in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-20-2015, 01:13 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