Gantt Chart Help

[mycon73]

Hi Users,

I created a Gantt Chart that I'm having difficulties modifying. Currently, I have a stacked bar chart & I wish to modify it to a clustered bar chart style.

When I do this, it changes my bars into a histogram style chart that I do not want. How can I modify my chart to a clustered style chart?

Also, is it it possible to milestones by placing some type of symbol that will move with my duration bars? Right now, I just have an image that I have to manually move.

I included an Excel 2007 for reference.

Thanks

[Andy Pope]

Milestones can be created using a xy-scatter series.

The stacked bar is required in order to generate the floating effect.

Can you explain what should be clustered?

[mycon73]

Hi Andy & Others,

Good tip with the X-Y scatter plot. I'll give that try. How would this work? I would want my milestone symbol to be on or at the end of my Actual Task duration bar, like it's currently shown in my example file.

If there is a way to make it dynamic with the rest of the chart, this would be great. As mentioned, this is currently a manual process, which is o.k. for the moment.

As for the bars, I should see the:

Planned Duration - Light blue bars going across the X-axis, which represents the beginning of each week.

This represents the planned start & end date for that particular tasks.


Actual Duration - The Green bar should be in a similar format, except, right under the light blue bar.

This represents actual start date & task duration.

Perhaps, that's what I'm missing. At the moment, in my Project X - WBS Tasks worksheet, I do not have a column for actual start date. At the moment, I thought I could use the (Est., Sched'd or Actual) Start Date column as both my estimated scheduled or start date, which was the original intent & still kind of want it to be.

How do you or others suggest to modify the duration bars?

Thanks for the assistance.

[Andy Pope]

You will need to alter you chart data layout.

You still need a padding start bar to give the floating effect. Then a separate series for Est and actual.

I have also added the xy-scatter series for milestones.

[mycon73]

Hi Andy!

Wow! This is cool..... Not quite what I was thinking I needed to do, but the results look good.

I did notice a couple of things:

Is there a way to get the task more centered between the Y grid lines

Also, on some of the tasks, such as Task 3 & 4, the bars still appear to be side-by-side, instead of stacked. Why is this?

Otherwise - This looks great & exactly what I'm looking for...

[mycon73]

Hi Andy,

Never-mind about the side-by-side bar concern. I see what I was doing.

[Andy Pope]

For the labels you could add an extra row to each task and then put the category label on the middle row of each set of data.
Set the Categories between ticks to 3. The Milestone marker could then be positioned in the 1st third of each tasks data.

Or do the labelling of the axis youself using another dummy xy-scatter series and linking data labels to cells.