|
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. : ) |
| All times are GMT +1. The time now is 07:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com