+ Reply to Thread
Results 1 to 3 of 3

Creating Timeline with XLS Spreadsheet

  1. #1
    Registered User
    Join Date
    08-21-2015
    Location
    Bali
    MS-Off Ver
    2010
    Posts
    12

    Creating Timeline with XLS Spreadsheet

    Hi Experts, I am creating a timeline chart with Conditional Formatting. Now I want to add some more functions to ease the operation and use:

    \1

    Untitled.png
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,323

    Re: Creating Timeline with XLS Spreadsheet

    Please explain in words in the thread what you are trying to add.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    08-21-2015
    Location
    Bali
    MS-Off Ver
    2010
    Posts
    12

    Re: Creating Timeline with XLS Spreadsheet

    ^^^Hello, thanks for replying.

    1) Yellow box on top left corner:
    Start Date is indicating the Date that this chart will be started. Eg, 7-Jul-2016 then the month on the right side will automatically start from 1-July-2016 onwards for 1 year (until 30-June-2017)
    2) TOD is the live date : when this project finish/live
    3) Month,date,and days are following the given month. Eg. July-2016 then the dates and day will follow it and so on
    4) Left side (task). Given #2 for Software, then the task below will auto-populate follow the #2. I think for this will be complicated, so for now just ignore it.

+ 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. Need help creating timeline and counting
    By jphilipson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-26-2016, 06:59 AM
  2. Creating a Project Timeline in Excel
    By garethterry in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-29-2013, 08:01 AM
  3. [SOLVED] Creating a timeline from Excel data
    By cubmar in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-18-2013, 03:22 AM
  4. Creating a pop-up timeline
    By Nicolas Mous in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-02-2013, 01:38 PM
  5. Q: Creating a timeline from a list of events
    By Matthew Clarke in forum Excel General
    Replies: 7
    Last Post: 01-31-2012, 06:57 PM
  6. Creating a Genealogy Timeline
    By Michael7 in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 08-24-2009, 08:57 AM
  7. [SOLVED] Creating formula for timeline
    By Lynne in forum Excel General
    Replies: 2
    Last Post: 04-13-2005, 06:06 AM

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