[Year 12 IT Apps] Excel Chart Help

[Meadows, Roslyn M]

In Excel 2007 - Right click on one of the dates and choose "format axis"
In Axis Options choose Auto for Minimum and Maximum
Personally I would also choose "Number" and format it as a date in the
form dd/mm/yyyy for more clarity, click OK

In Excel 2003 - Right click on one of the dates and choose "format
axis", choose the number tab and choose date and the form of dd/mm/yyyy
Click OK
Then right click on the dates and choose format axis again, choose the
scale tab, untick the boxes for minimum and maximum and set the date
range your project runs over. Click OK

Hopefully this will work

You could also consider using OpenProj
http://sourceforge.net/projects/openproj/ 
Cheers
Ros

Roslyn Meadows
Head of ICT Implementation
Head of Assessment and Reporting
Bentleigh Secondary College 
| 9579 1044 | 0412 614 062 |

Please consider the environment before printing this email 
In some cases, all it requires is that you rationally point out that
there is a problem. 
In others, all you can do is turn the other cheek. 
At the far end of the spectrum are those for whom the only appropriate
response is to carve out their still-beating heart and force them to eat
it. (Marc Carlson)

-----Original Message-----
From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Daniel Stanley
Sent: Tuesday, 27 May 2008 10:11 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] Excel Chart Help

Good morning all,

Attached is an excel file that I have been using as a Gantt chart tool.
There is a chart in it with which I am having some trouble.  The dates
are set to 2007, and I can't work out how to make it show data on the
chart with a current date. 
Any assistance you can give would be much appreciated.

Thanks all,

Daniel 


 
Daniel Stanley
IT Co-ordinator | Carrum Downs Campus
Flinders Christian Community College
e: daniel.stanley at flinders.vic.edu.au
w: 03 97850000 ext:327
m: 0423960800
f:   03 97735710

"Never laugh at live dragons..."
The Hobbit - J.R.R. Tolkien

_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au  - VITTA Victorian Information Technology
Teachers Association Inc

Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.