| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
: ) 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. : ) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart Date X Axis | Charts and Charting in Excel | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
| Line chart - date line association gone mad! | Charts and Charting in Excel | |||
| calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions | |||
| Inserting Blank Rows Macro? | Excel Worksheet Functions | |||
Linear Mode
