+ Reply to Thread
Results 1 to 2 of 2

Bar chart creation

  1. #1
    Registered User
    Join Date
    10-14-2009
    Location
    Pretoria, South Africa
    MS-Off Ver
    Excel 2003
    Posts
    3

    Bar chart creation

    Hi, I am assuming this is a very basic and often used chart. But I am unable to figure it out so hopefully somebody can help.

    I want to create a progress bar chart for a software developing project that has many tasks and I want to show in 2 shads per bar 1. how many days have been worked on the task and 2. how many days are left on the task.

    I would like then to on the left horizontal axis show the task names and then on top or bottom show months with the horizontal bars in the meat of the graph per task.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,130

    Re: Bar chart creation

    You need to create a gantt chart.
    Normally this is 2 stacked bar series. 1st series is the start date, second series is the duration.

    If you want completion you will need to use a 3rd series and calculate differences between total duration and completed.

    try search forum for gantt

    post example workbook if confused.
    Cheers
    Andy
    www.andypope.info

+ 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