|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
 |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
04-29-2005, 01:06 AM
|
|||
|
|||
|
How do I chart date ranges with varying start and finish dates?
I want to create a chart that on one axis will show date ranges that have
varying start and finish dates. The other axis is a list of project names. Example: Project #1, starts 5/1/05, ends 10/1/05; Project #2 starts 3/5/05, ends 2/2/06, etc. I want a bar chart that I can sort. Any help is very appreciated. : ) 
|
|
#2
04-29-2005, 10:06 AM
|
|||
|
|||
|
RE: How do I chart date ranges with varying start and finish dates?
It sounds like you need to create a Gantt chart. Here are some resources
that might help: http://www.peltiertech.com/Excel/Charts/GanttLinks.html http://www.peltiertech.com/Excel/Charts/GanttChart.html http://pubs.logicalexpressions.com/P...cle.asp?ID=343 ---- Regards, John Mansfield http://www.pdbook.com "projectplanner" wrote: > I want to create a chart that on one axis will show date ranges that have > varying start and finish dates. The other axis is a list of project names. > Example: Project #1, starts 5/1/05, ends 10/1/05; Project #2 starts 3/5/05, > ends 2/2/06, etc. I want a bar chart that I can sort. Any help is very > appreciated. : )
|
|
#3
04-30-2005, 02:06 PM
|
|||
|
|||
|
RE: How do I chart date ranges with varying start and finish dates
Wow. Thank you, John. I think I am in love. PERFECT help info, just what I
needed. "John Mansfield" wrote: > It sounds like you need to create a Gantt chart. Here are some resources > that might help: > > http://www.peltiertech.com/Excel/Charts/GanttLinks.html > > http://www.peltiertech.com/Excel/Charts/GanttChart.html > > http://pubs.logicalexpressions.com/P...cle.asp?ID=343 > > ---- > Regards, > John Mansfield > http://www.pdbook.com > > > "projectplanner" wrote: > > > I want to create a chart that on one axis will show date ranges that have > > varying start and finish dates. The other axis is a list of project names. > > Example: Project #1, starts 5/1/05, ends 10/1/05; Project #2 starts 3/5/05, > > ends 2/2/06, etc. I want a bar chart that I can sort. Any help is very > > appreciated. : )
|
|
#4
04-30-2005, 11:06 PM
|
|||
|
|||
|
Re: How do I chart date ranges with varying start and finish dates
Hey, he didn't do any of the work!
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ projectplanner wrote: > Wow. Thank you, John. I think I am in love. PERFECT help info, just what I > needed. > > "John Mansfield" wrote: > > >>It sounds like you need to create a Gantt chart. Here are some resources >>that might help: >> >>http://www.peltiertech.com/Excel/Charts/GanttLinks.html >> >>http://www.peltiertech.com/Excel/Charts/GanttChart.html >> >>http://pubs.logicalexpressions.com/P...cle.asp?ID=343 >> >>---- >>Regards, >>John Mansfield >>http://www.pdbook.com >> >> >>"projectplanner" wrote: >> >> >>>I want to create a chart that on one axis will show date ranges that have >>>varying start and finish dates. The other axis is a list of project names. >>>Example: Project #1, starts 5/1/05, ends 10/1/05; Project #2 starts 3/5/05, >>>ends 2/2/06, etc. I want a bar chart that I can sort. Any help is very >>>appreciated. : )
|
|
#5
05-01-2005, 08:06 PM
|
|||
|
|||
|
Re: How do I chart date ranges with varying start and finish dates
: ) Then you get kisses, LOTS of 'em!
xxxxxxxxxxxxxxxx... Nancy projectplanner "Jon Peltier" wrote: > Hey, he didn't do any of the work! > > - Jon > ------- > Jon Peltier, Microsoft Excel MVP > Peltier Technical Services > Tutorials and Custom Solutions > http://PeltierTech.com/ > _______ > > projectplanner wrote: > > > Wow. Thank you, John. I think I am in love. PERFECT help info, just what I > > needed. > > > > "John Mansfield" wrote: > > > > > >>It sounds like you need to create a Gantt chart. Here are some resources > >>that might help: > >> > >>http://www.peltiertech.com/Excel/Charts/GanttLinks.html > >> > >>http://www.peltiertech.com/Excel/Charts/GanttChart.html > >> > >>http://pubs.logicalexpressions.com/P...cle.asp?ID=343 > >> > >>---- > >>Regards, > >>John Mansfield > >>http://www.pdbook.com > >> > >> > >>"projectplanner" wrote: > >> > >> > >>>I want to create a chart that on one axis will show date ranges that have > >>>varying start and finish dates. The other axis is a list of project names. > >>>Example: Project #1, starts 5/1/05, ends 10/1/05; Project #2 starts 3/5/05, > >>>ends 2/2/06, etc. I want a bar chart that I can sort. Any help is very > >>>appreciated. : ) > >
|
|
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
