LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
meris
 
Posts: n/a
Default gnatt chart in excel?!

Hi
Im trying to create a schedule of classes in different locations. I would
like to have them displayed in a €œgnatt chart€, however im having difficulty
trying to get the chart wizard to make it for me.

The classes are scheduled at different dates, run for different lengths of
time and are in different locations. There will also be classes in different
locations at the same time.

Is it possible to display this sort of data in a chart form in excel, and if
it is, how do I do it? I can leave the start & finish times out, it is the
dates and the class numbers that are the most important

Data sample:

Class # Start Date Days of Week Times (To €“ From) Finish Date
1 3 April 06 Mon - Thurs 6:30pm €“ 9:00pm 13 April 06
2 15 April 06 Sat & Sun 9:00am €“ 4:00pm 16 April 06
3 17 April 06 Mondays 6:30pm €“ 9:30pm 15 May 06
4 15 April 06 Sat - Thurs 6:30pm €“ 8:00pm 19 April 06

Im using a stacked bar graph at the moment and the data is all over the
place! Any help would be greatly appreciated
Thanks
Mary

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart Property Confusion Arturo Charts and Charting in Excel 4 December 16th 05 05:13 AM
replace axis text with graphics on excel chart (excel 2003) Mad_Hatter_29 Charts and Charting in Excel 3 December 6th 05 01:42 PM
tick mark labels Debrane Charts and Charting in Excel 9 July 19th 05 02:53 AM
Using Microsoft Excel Chart object in VB6 fizbim Charts and Charting in Excel 0 July 13th 05 05:14 PM
Copying an Excel chart into a Word document Carolyn Excel Discussion (Misc queries) 7 July 11th 05 07:29 PM


All times are GMT +1. The time now is 11:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"