+ Reply to Thread
Results 1 to 3 of 3

Timeline Gantt chart - Chart bars are in reverse order

  1. #1
    Forum Contributor
    Join Date
    03-13-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    152

    Timeline Gantt chart - Chart bars are in reverse order

    Hi,

    Please have a look at the attached files.

    Project timeline example - working.xlsx - The file I am working on.
    Project timeline example.xlsx - Example file downloaded online. Using this file I have created the above file.

    The problem is I don't get the bars right. Please look at the 'SURVEY PROGRAMMING' milestone (row 2) in 'Project timeline example.xlsx'. That milestones starts on 26th march and ends on 29th march. The yellow bar starts on 26th march and ends on 29th march with orange button. But in my file 'Project timeline example - working.xlsx' both yellow bar and orange button falls on the end date of the milestone. I tried to fix the issue but couldn't. Kindly help me to fix this issue.

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,482

    Re: Timeline Gantt chart - Chart bars are in reverse order

    The problems are that

    1. You inserted a column "Days" in project Timeline sheet but did not change the named range formula "Gridcalc"
    2. you created a not working formula yourself in sheet cals to replace the =Gridcalc formula that was in there

    after changing all references to column E to F in the Gridcalc named range formula
    and reinstating that formula in the cals sheet it works again..

    when downloading a template you have to spend time to understand how it was build. Otherwise changes you make are quite random and not in line with the logic of the design of the sheet

  3. #3
    Forum Contributor
    Join Date
    03-13-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    152

    Re: Timeline Gantt chart - Chart bars are in reverse order

    Thank you so much Roel Jongman for taking time to look into this issue and for the great explanation. Now I understand where I did the mistake.

    Added rep.

+ 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. [SOLVED] Timeline or Gantt Chart with times by minutes/hours rather than days
    By dvs in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 01-13-2021, 09:53 AM
  2. [SOLVED] Need a Timeline on my X axis for a Gantt chart
    By noboffinme in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-02-2018, 11:24 PM
  3. Gantt Chart - Different colors on the bars
    By davidstokes in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 08-28-2018, 08:47 PM
  4. A Dynamic Timeline Gantt Chart
    By Uttam123 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-15-2013, 02:09 AM
  5. Timeline (Gantt) chart showing both hour and date
    By S K ROY in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-30-2011, 06:33 PM
  6. Excel Autofill/Timeline/Gantt Chart
    By Rivendair in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2011, 09:43 PM
  7. Replies: 5
    Last Post: 05-20-2011, 10:00 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