Modify Gantt Chart Dates

Hi,

I recently found a Gantt Chart file / template that I would like to use with one of my projects.

In the the chart, it currently has a date range from 1997 - 1998.

I attempted to modify the X Axis option, but do not see the area to modify the data ranges to 2011 dates. I may want to replace with Fiscal Weeks instead.

How & where can I change these?

I attached an example (Excel 2007) file.

Thanks

Hi,

I think I figured out part of the issue.

The date in the Gantt chart is some type of serial date, such as: 35793.0, which I think represents 12/29/1997.

How do I update this to current dates? Also, if I rather use Fiscal Weeks, instead of dates, how or where can I change this in the file?

Thanks

Hi,

To help convey my questions better, I made a 1-slide presentation?

I have 2 questions:

1) How to change or update the serial number or integer (not sure which this is) to current dates within my table or to use Fiscal Weeks

2) How can I space out my tasks & still continue to show all tasks.

Please see slide & advise.

Thank you.

Oops,

It doesn't look like a '.pptx' file was accepted when attempting to upload. Here's a Word doc.

Thanks

Hi Everyone,

It took a while, but I finally figured out what these serial numbers meant & how to use them.

Thanks for the help....