If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
gnatt chart in excel?!
Hi,
Jon Peltier has an article on gantt charts, http://pubs.logicalexpressions.com/P...cle.asp?ID=343 and a collection of links on his own site, http://peltiertech.com/Excel/Charts/GanttLinks.html Cheer Andy meris wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users | 5 | October 27th, 2005 03:06 AM |
excel chart linked into access report | wayne | New Users | 0 | October 22nd, 2005 12:55 AM |
Set custom chart type from MS Access 97 to Excel 2000? | NoSpamTakeSquareRootOfNumber | Charts and Charting | 4 | July 13th, 2004 05:43 PM |
resizing chart title box Excel 97 | Andy Pope | Charts and Charting | 1 | February 28th, 2004 03:26 AM |