Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    Durham, North Carolina, USA
    Posts
    140
    Thanks
    5
    Thanked 1 Time in 1 Post

    Faking a Gantt chart (Excel XP)

    Hi everyone,

    I'm supporting a department who wants to see their data in a format that looks like a Gantt chart. They don't have Project and would prefer not to use it.

    I've created a bar chart of their data that looks like a Gantt chart, but I'm running into 2 problems.

    1) The bars all show as having the same start date. Is there a way to create a bar chart where the left side of the bars "float"? In other words, I want each bar to start on its real date, not on the X axis.

    2) I want the Y axis major gridlines to be by year, and the minor gridlines to be each quarter in the year. So far, I have not been able to format the axis that way.

    I've attached the Excel file that represents my progress. Can anyone help me out?

    Thanks in advance,

    Beej

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Faking a Gantt chart (Excel XP)

    Check out Re: Gant Charts for some suggestions.

    Most times it is a matter of using stacked bars and setting no fill or lines for the lower bar to make the items "float" (which means making intermediate data to plot correctly)

    Steve

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Faking a Gantt chart (Excel XP)

    Jon Peltier also has a Gantt Chart example that may help you in creating one.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •