+ Reply to Thread
Results 1 to 3 of 3

Charts with setting starting and ending point on x (time)

  1. #1
    Registered User
    Join Date
    07-24-2008
    Location
    Russia
    Posts
    1

    Charts with setting starting and ending point on x (time)

    Hi, there. i would like to make something like this:

    http://img392.imageshack.us/img392/9474/outputuu8.jpg

    [IMG="http://img392.imageshack.us/img392/9474/outputuu8.jpg"[/IMG]

    I have a lot of starting and ending times and i would like to add it on a square on axis x (time like) and i want to group the multiples on the same line (alpha, beta etc).

    I'm not so good on charting so any hint, advice or oppinion will be appriciated.

    Thanks in advance.
    Yuri.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436
    That's a gantt chart.
    You will need to change the layout of your data and use formula to recalculate the duration of each item. Plus the start point of any multiple items

    http://pubs.logicalexpressions.com/P...cle.asp?ID=343
    http://peltiertech.com/Excel/Charts/GanttLinks.html
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-24-2008
    Location
    Cambridge UK
    Posts
    53
    Or, you could download a ready-made template for free from here:

    http://www.vertex42.com/ExcelTemplat...ntt-chart.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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