Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Timelines

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Timelines

Resolved · Low Priority · Version 2003

Reply Tue 3 Nov 2009, 15:56Delegate Louise said...

Louise has attended:
Excel Introduction course

Timelines

Creating timelines.

For upcoming training course dates see: Pricing & availability

Reply Thu 5 Nov 2009, 10:18Trainer Anthony said...

RE: Timelines

Hi Louise, thanks for the query. You can create charts with time as the horizontal axis, but if you want staggered bars on the chart it gets a bit more complicated. You'll need some dummy data and the corresponding column formatted as white to position the time bar. Alternatively, tracking the progression of tasks is more usually done in a Project Management software package such as MS Project using a Gantt chart.

Hope this helps,

Anthony

Wed 11 Nov 2009: Automatically marked as resolved.

Excel articles

· Microsoft Excel Training: Not Just for Newbies Anymore
· Chart Creation Simplified - in 4 Simple Steps
· Don't Get Lost In A Sea Of Data, Use Excel Navigation
· Plug Into The Big Grid
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips

Please browse our web site to find out more about
basic training excel and other Microsoft training courses.

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips