PowerPoint Reports

Hi Christine

Thank you that is really helpful.

I found an interesting article on creating a Gantt Chart style chart in Excel which could be a way in (although it's for an earlier version of Excel the principle of adapting a chart to appear as a Gantt chart seems to fit here)

http://office.microsoft.com/en-gb/excel-help/create-a-gantt-chart-in-excel-HA001034605.aspx

In Project you may find the Remaining and Scheduled Duration values useful in the Duration field collection

When it comes to formatting the dates you can double click on the Axis and in Format Axis > Number set the Format Code to create the result you are looking for. For example mmm will produce a 3 letter month name (May Jun Jul) and mmmm will show the full month name.

I found a project template that has a similar (though not identical chart which might be a good starting point.

Try making a new project and choosing the Software Development template. Take a look at the report called Software Development Plan (it's in Report > Custom).

See if this gets closer to the result you are looking for and let me know how you get on.

Kind regards,
Andrew