Thread: 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. : )

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. : )

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. : )

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. : )

: ) 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. : )
>
>