excel ghantt chart to show plan and actual per activity

[ashleywanless]

Ghantt Charts​

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>​

I have created a Ghannt chart in excel (well a stacked bar chart that looks like a ghantt chart).
<o> </o>
Is there any type of chart I can use that will mirror this (date’s on the Y axis, activities on the X axis) but that allow me to show two bars for each activity, one below the other. I am looking to display the estimated and actual activity dates on the timeline.
<o> </o>
The only way I have been able to do this currently is to have 2 activities per activity (1 ends with plan, the other actual) this doesn’t look that pretty though.
<o> </o>
Thanks

 

[psrs0810]

Do a simple search for excel ganntt chart. There are links on how to build one using a horzontial bar graphs to MS having a downloadable template.

 

[ashleywanless]

I have searched the net and all of these seem to only be for one bar per activity, not a bar under bar approach as i would like. Do you have any links in particular that may help?

thanks