+ Reply to Thread
Results 1 to 3 of 3

To-do List Horizontal Bar Graph

  1. #1
    Registered User
    Join Date
    03-29-2011
    Location
    Hobart, Australia
    MS-Off Ver
    Excel 2003
    Posts
    5

    To-do List Horizontal Bar Graph

    I want to create a graph where it lists the thing to-do on the y-axis and the dates during which that thing will be done on the x-axis. ie.

    thing a|¸¸¸¸¸¸¸¸-------
    thing b|¸¸¸¸¸¸¸¸¸¸¸¸-------
    thing c|¸¸¸¸¸¸¸¸¸¸¸¸¸¸¸------------
    thing d|¸¸¸¸¸¸¸¸¸¸¸¸¸¸¸¸¸¸¸¸¸¸----------
    thing e|¸¸¸¸¸¸¸¸¸¸¸¸¸¸¸¸¸------------
    thing d|¸¸¸¸¸¸¸¸¸¸¸¸¸¸¸¸¸¸¸----
    ¸¸¸¸¸¸¸¸¸¸ˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉˉ
    ¸¸¸¸¸¸¸¸¸¸¸¸¸¸¸1/2 13/2 31/2

    with the '¸' being just empty space, this stupid thing doesn't allow multiple spacebars in a row!
    Last edited by justinb2; 03-29-2011 at 11:10 PM.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: To-do List Horizontal Bar Graph

    Hello,

    create a data table with an anchor date, a start date and an end date for each task. Calculate the duration of each task in days and then stack the data into a horizontal bar chart. make the first data series invisible with no fill and no border. See attached.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-29-2011
    Location
    Hobart, Australia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: To-do List Horizontal Bar Graph

    Awesome, thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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